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

Thread: Move Database

  1. #1
    Join Date
    Feb 2000
    Posts
    17
    I created a database using the automatic database creation feature when I installed Oracle 8.1.6EE. Now I would like to move the database to another drive and create an additional database on still another drive. How do I do this and get Oracle to recognize where the databases are located?
    Thanks for any help.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    1. document where your existing files live. (v$controlfile, v$datafile, v$logfile, init.ora, orapw file)
    2. shutdown immediate
    3. do a cold backup
    4. move your files to their new locations
    5. edit your init.ora file for path specific info
    6. startup mount
    7. alter database rename file 'old_path_and_file' to 'new_path_and_file' for each data file
    8. alter database open
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Feb 2000
    Posts
    17

    Thanks

    Thank you for your answer.

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