Re: dbspace

Use TBUNLOAD drop database TBLOAD Thuc Nguyen <thucn@inconnect.com> wrote in article <32ADA227.648F@inconnect.com>... > 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 >