>
> Hi Ari,
>
> I wish you a Happy New Year.
>
> Could you give me a reply on What are the steps I have
> to do to rename an existing Oracle 7.3.2 database on HP-UX 10.20
> system?
>
> Thanks in advance.
>
> Girish
>
>
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com
>
It's a lot of work. There are a few methods:
1) Create the new database with new files, export the old database, import
into the new database, then delete the old database
2) Issue "ALTER SYSTEM BACKUP CONTROLFILE TO TRACE", then modify the trace
file that is generated in the ../udump directory. Change the name of the
database there. Shut down the database. Set the ORACLE_SID environment
variable to the new SID name. Move all datafiles to new directories per OFA
compliance. Modify the trace file again to reflect the file locations, and
run the script.
3) Be sure to modify all sdcripts that point to the old SID, and change the
GLOBAL name so that Oracle's networking software can properly determine the
database when making connections.
Please read the documentation on the CREATE CONTROLFILE command, as I cannot
take responsibility for anything bad that may happen.
-Ari Kaplan
Independent Oracle DBA Consultant
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 150+ Oracle tips, visit my Web Page: <->
<-> <->
<-> www.arikaplan.com <->
<-> <->
<-> email: akaplan@interaccess.com <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
Back to Ari Kaplan's Home Page