Re: How to rename a database

From: Lando <mlanda_at_earthlink.net>
Date: 1998/01/25
Message-ID: <34CC226C.4C3B859@earthlink.net>#1/1

In your create controlfile script change DATABASE "PROD" to SET DATABASE "TEST" .

If you are coping from a production instance to at test/development instance you will also want to change "ARCHIVELOG" to "NOARCHIVELOG" and "NORESETLOGS" to "RESETLOGS". When you open the
database make sure to use:
alter database open resetlogs;
Finally, once you get the database open you probably want to do: alter database rename global_name to test.

Of course, replace the database names I used with your database names.

M.Landa

Raymond K.W. Lau wrote:

> How to rename a Oracle 7.3.3 database ?
> When I try to recreate the controlfile with a new db_name. The ORA-01161
> will
> pop up saying that the system datafile header has different database name.
>
> Thanks for any advice !
Received on Sun Jan 25 1998 - 00:00:00 CST