1. change the dbname and instance name in the pfile
2. recreate the control file using the new dbname and instance name
3. open db

-----Original Message-----
From: dgaikwad
[mailto:oracledba-ezmlmshield-x62637927.[Email address protected]
Sent: Monday, April 30, 2007 11:14 AM
To: LazyDBA Discussion
Subject: Urgent Help.

Hi DBA's

I had created database using but i want to rename the database.
so, What i want to do?

PLs its urgent.

Thanks & Regards,
Dinesh G.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


http://www.mtnonline.com/contact/disclaimer.asp

Oracle LazyDBA home page