Re: Changing a database name
From: Horace Chow <horacecw_at_netvigator.com>
Date: Sun, 19 Jul 1998 10:20:01 +0800
Message-ID: <35B157D0.8419B9DD_at_netvigator.com>
If you want to change the INSTANCE name only, try it
Date: Sun, 19 Jul 1998 10:20:01 +0800
Message-ID: <35B157D0.8419B9DD_at_netvigator.com>
If you want to change the INSTANCE name only, try it
1. Shutdown the database
2. set the environment variable $ORACLE_SID as your new database
name
3. restart your database using the original pfile.
If you want to rename the physical database name which stored in the controlfile, then you have to recreate it.
1. Backup the controlfile to trace
2. Modify the controlfile recreation script
3. Shutdown your database
4. Startup the database in nomount state
5. Recreate your controlfile
For detail, please refer to the manaul.
Horace Received on Sun Jul 19 1998 - 04:20:01 CEST