Re: Changing a database name

1. create a control by issuing:

    alter database backup control file to trace;

2. edit the text file from user dump area generated by step1,

     change 'reuse database your_dbname' to 'set database your_new_dbname';

3. modify your init.ora to reflect the db name;

4. run the modified script;

then you get a db name.

To be sure, you have a full db backup before proceed.

Best Regards,

Komix Hui
Andries wrote:

> Does anybody know how to change the name of a already created database,
> i am running oracle 7.3.2 on AIX
> Any help would be appreciated.
>
> Andries
Received on Mon Jul 27 1998 - 08:03:54 CEST