Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Renaming a Database
You can do a
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
then find the trace file in the bdump directory, edit it, so that
the CREATE CONTROLFILE statement looks something like
CREATE CONTROLFILE REUSE SET DATABASE "NEWNAME" RESETLOGS NOARCHIVELOG ...
Shut the database down normal, back it up.
Modify the init.ora db_name=newname
Run the create controlfile script from the bdump directory
Then,
ALTER DATABASE RENAME GLOBAL_NAME TO nename.domain;
Received on Fri Oct 10 1997 - 00:00:00 CDT