dcsimg
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: PROCEDURE TO RENAME THE DATABASE

  1. #1
    Join Date
    Mar 2002
    Posts
    200
    I know you have to recreate the control file if you want to rename the database. But can someone please explain the step-step procedure to rename the database.

    QUESTER.

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Assuming v8.1.7

    1. svrmgrl
    2. connect internal
    3. alter database backup controlfile to trace;
    4. modify trace output, modifying CREATE CONTROLFILE... line to SET and new name.
    5. shutdown the database
    6. remove the old controlfiles
    7. run the script created in step 4

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Mar 2002
    Posts
    200

    Originally posted by jovery
    Assuming v8.1.7

    1. svrmgrl
    2. connect internal
    3. alter database backup controlfile to trace;
    4. modify trace output, modifying CREATE CONTROLFILE... line to SET and new name.
    5. shutdown the database
    6. remove the old controlfiles
    7. run the script created in step 4

    Regards
    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width