Re: dbspace
In article <32ADA24E.784@inconnect.com>, Thuc Nguyen
<thucn@inconnect.com> writes
>Hi
>
>Before I was hired, another non-DBA SA wrote a script:
>
>create database coris>
>that went to rootdbs automatically, I believe
>
>It showed as
>
>Database Name Owner In Dpspace When Created Log Status
>
>coris informix rootdbs 01/24/96 B
>
>
>but
>
>It should be
>
>Database Name Owner In Dpspace When Created Log Status
>
>coris informix coris1dbs 01/24/96 B
>
>
>coris1dbs is where the data/dbschema information is located in.
>
>How can I change from rootdbs to coris1dbs?
>
>dbexport>drop rootdbs
>create database coris in coris1dbs>new schema
>dbimport>
>Is there another way to make it easier?
>
>Thanks for your help
>
>Thuc
>
No - you need to export and then reimport the database. It's the kind
of thing you need to do right first time.
--
David Williams