Re: dbspace

Thuc Nguyen wrote: > > 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 DON'T DO THIS ! > create database coris in coris1dbs> new schema > dbimport dbexport .... dbaccess -> database -> drop -> coris dbimport -c -q (-l -ansi ?) -d coris1dbs coris> > Is there another way to make it easier? > > Thanks for your help > > Thuc -- With best regards Markus Holzbauer markus.holzbauer@mch.sni.de Online or not Online, that's the question here !?