Re: Oracle8/Nt How do I rename instance?

From: Simon Quinn <simon.quinn_at_syntegra.bt.co.uk>
Date: Tue, 03 Nov 1998 16:45:58 +0000
Message-ID: <363F3345.44D2FDD5@syntegra.bt.co.uk>

Haven't tried it on NT but the following method works on Unix:

backup the control file, ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

Shutdown the database normally.

Rename your initORCL.ora to the new database name and change the DB_NAME parameter

Edit the trace file which contains the create controlfile statement and change the line
CREATE CONTROLFILE REUSE DATABASE "ORCL" NORESETLOGS ARCHIVELOG to
CREATE CONTROLFILE SET DATABASE "newname" RESETLOGS ARCHIVELOG

Delete the control files.

Start the database using STARTUP NOMOUNT;

Run the above script that you've modified.

Open the database using ALTER DATABASE OPEN RESETLOGS;

arivlin_at_my-dejanews.com wrote:
>
> I installed Oracle Personal8 on NT4. Default name for the database is ORCL. I
> want to rename it to something more meaningful. How can I do that?
> Unfortunately I already put some data in the database, so I do not want to
> build a new parallel DB. Thank you in advance. Alex
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Nov 03 1998 - 10:45:58 CST