Re: dbspace

David Williams <djw@smooth1.demon.co.uk> wrote: >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 I don't think there is any reason to drop the rootdbs - don't you mean drop database database name? >>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 _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Gordon E. Hooker MACS PCP 25 Clarke Street Ripley Queensland Australia Phone 61-7-32940555 Email gordonh@thehub.com.au _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ We are just two lost souls living in a fish bowl Year after year Pink Floyd