Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Markus G. Holzbauer — — source: Informix-list mailing list archive (1991-1998)
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 !?
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.