Home » RDBMS Server » Server Utilities » Renaming a database
Renaming a database [message #74756] Sat, 12 February 2005 04:04 Go to next message
Keerthana
Messages: 1
Registered: February 2005
Junior Member
Can someone please tell me the steps to rename a database in Oracle9i? Urgent. Respond asap please.

Report message to a moderator

Re: Renaming a database [message #74761 is a reply to message #74756] Mon, 14 February 2005 00:35 Go to previous message
devika
Messages: 21
Registered: November 2004
Junior Member
Hello Keerthana,

To rename a database recreate the control file and instead of REUSE database specify it as SET database and change the db_name parameter to new name in the pfile

Report message to a moderator

Previous Topic: while loading data using SQL*Loader--error--ORA-01722: invalid number
Next Topic: Facing Problem during Importing Data using IMP.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 25 18:28:38 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.