Home » RDBMS Server » Backup & Recovery » Rename a database
Rename a database [message #192120] Mon, 11 September 2006 01:36 Go to next message
barjunreddy
Messages: 8
Registered: August 2006
Location: Hyderabad
Junior Member
Hi Gurus,
I Would like to rename the existing abc database as xyz. Could anyone tell me the steps to rename a database to the new name.

I tried the following steps

SQL>SELECT NAME FROM V$DATABASE;
ABC

SQL>ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
DATABASE ALTERED;

SQL>SHOW PARAMETER USER_DUMP_
D:\oracle\admin\XYZ\udump

SQL>SHUTDOWN IMMEDIATE;
CD TO USER_DUMP DIRECTORY

Copied the Newly generated .trc file

Then after i dono what to do??

Regards,
Nagarjun.
Re: Rename a database [message #192214 is a reply to message #192120] Mon, 11 September 2006 07:52 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
duplicate post.
Please do not flood the forum with duplicate postings.

[Updated on: Mon, 11 September 2006 07:52]

Report message to a moderator

Previous Topic: ora 4030 while using logminer
Next Topic: database clonning with different instances
Goto Forum:
  


Current Time: Wed Dec 07 08:42:18 CST 2016

Total time taken to generate the page: 0.14897 seconds