| Rename a database [message #192120] |
Mon, 11 September 2006 01:36  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
