Thanks Chetan
I'm using Oracle 7.3 running on NT
I can't find the two files you mentioned
Do I CREATE a new DATABASE over the existing ones?
Thanks
J
Chetan Wagle wrote in message <7sf4k7$3pk$1_at_herald.ctp.com>...
>Hi Joe,
>
> What you will have to do is the foll steps (I assume u are on UNIX) :
>
>1. Goto ORACLE_HOME/rdbms/install/rdbms and locate two files called
crdb.orc
>and crdb2.orc. Rename these to .sql and edit them properly to create the
>database the way you want it to be.
>2. Create the init.ora and config.ora files
>3. Set your ORACLE_SID etc properly and run svrmgrl
>4. Run the crdb.sql script followed by crdb2.sql script
>5. Run ORACLE_HOME/rdbms/admin/catalog.sql, catproc.sql and catexp.sql
>
>Now you have two Oracle instances with the same ORACLE_HOME.
>
>It would help to seek the guidance of someone who ahas already done this
>operation.
>
>HTH,
>Chetan
>
>
Received on Fri Sep 24 1999 - 07:36:50 CDT