How rename a database?
What are the steps for renaming a database? I took the trace file and created a sql script to create a new controlfile. In the sql script for creating the controlfile I changed the database name. However when I try the script the error message is that the info in the header files do not match. What am I missing in this procedure? Oracle 8.0.6 on NT. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Connie Milliken INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How rename a database?
Hi, You need to replace the keyword REUSE with SET i.e. CREATE CONTROLFILE REUSE DATABASE "OHIR1" NORESETLOGS NOARCHIVELOG should be CREATE CONTROLFILE SET DATABASE "OHIR2" NORESETLOGS NOARCHIVELOG HTH, Rajesh -Original Message- Milliken Sent: Saturday, March 10, 2001 10:15 PM To: Multiple recipients of list ORACLE-L What are the steps for renaming a database? I took the trace file and created a sql script to create a new controlfile. In the sql script for creating the controlfile I changed the database name. However when I try the script the error message is that the info in the header files do not match. What am I missing in this procedure? Oracle 8.0.6 on NT. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Connie Milliken INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How rename a database?
In the control file user the set database option to rename ur database. -- On Sat, 10 Mar 2001 10:15:24 Connie Milliken wrote: >What are the steps for renaming a database? I took the trace file and >created a sql script to create a new controlfile. In the sql script for >creating the controlfile I changed the database name. However when I >try the script the error message is that the info in the header files do >not match. What am I missing in this procedure? > >Oracle 8.0.6 on NT. > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Connie Milliken > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > Get 250 color business cards for FREE! at Lycos Mail http://mail.lycos.com/freemail/vistaprint_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).