> Hi! Ari 
> How are u
> I am a starter DBA and I want to change the name of my existing database
> how can i do this pls help me out.
> thanks in advance
> Susheel kumar
> susheelkr@hotmail.com

There are two ways to do this:

1) Create a new database with the new name and datafiles.
   Export the old database.
   Import the old database into the new database.

2) Issue "alter database backup controlfile to trace" - this will create a
   "create controlfile" file in the ../udump directory. You will have to
   carefully modify this script, noting any changes in the location of files
   (which you may want to do to stay OFA compliant). Also, add the appropriate
   renaming command in the appropriate location (see the SQL reference manual).
   BACKUP THE DATABASE after shutting it down.
   Run the script after setting your ORACLE_SID environment variable to the
   new database name.

In both methods, be sure to modify the /etc/oratab (if in UNIX) and any
scripts that may reference the database name, such as backup scripts.

Best of luck!

-Ari Kaplan
Independent Oracle DBA Consultant

<-> For 175+ Oracle tips, visit my Web Page:                      <->
<->                                                               <->
<->             www.arikaplan.com                                 <->
<->                                                               <->
<->             email: akaplan@interaccess.com                    <->

Back to Ari Kaplan's Home Page .htm"> Back to Ari Kaplan's Home Page