Re: Rename Database

The database can be renamed by recreating the controlfile as outlined below. Simply backup the control to trace (alter database backup control to trace; , the trace file will end up in the user dump dest) and edit the file using the below script as a template. If you have global names set to true don't forget to alter the global names as well otherwise any database links that you create will fail.

CONNECT INTERNAL
STARTUP NOMOUNT CREATE CONTROLFILE REUSE SET
 DATABASE “TEST“
 RESETLOGS ARCHIVELOG
 MAXLOGFILES 255
 MAXLOGMEMBERS 3
 MAXDATAFILES 1022
 MAXINSTANCES 1
 MAXLOGHISTORY 100
LOGFILE
 GROUP 1 ‘logfile‘ SIZE 5M,
 GROUP 2 ‘logfile‘ SIZE 5M,
 GROUP 3 ‘logfile‘ SIZE 5M
DATAFILE
 ‘datafile‘,
 ‘datafile‘,
 ‘datafile‘
;

alter database open resetlogs;
alter database rename global_name to TEST;

LTB AXK wrote:

> Hello,
>
> i have an Oracle Instance (Name: Test). Now i want rename the instance Name
> to XXXX. What must i do??
> I work with Oracle 7.3.4.2 and the operating system is Windows NT SP5.
>
> Thanks for your Help
>
> Regards.
>
> Axel
Received on Thu Nov 04 1999 - 08:55:20 CST