dbspace
Posted in 1996
Thuc Nguyen — — source: Informix-list mailing list archive (1991-1998)
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?
dbexportdrop rootdbs
create database coris in coris1dbsnew schema
dbimport
Is there another way to make it easier?
Thanks for your help
Thuc