move an oracle database from one drive to another
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 11

Thread: move an oracle database from one drive to another

Threaded View

  1. #1
    Join Date
    Nov 2005
    Posts
    4

    move an oracle database from one drive to another

    Hi,
    I have been searching for a example of how to move a database from one server to another. The database is pretty big (15 2gb data files and 10 more 2gb index files) and I would rather not have to .dmp it out and reload it. Its a development db so the performance hit of it being on a network drive is not much of a concern to me.

    I am not very skilled in the way of oracle so please be detailed. Thanks in advance for your help

    Heres the skinny.

    Both computers are windows. The database server is oracle 9i and is on box 'A' for simpicity sake. I want to move the db files to box 'B' and just map a drive from box A to box B

    Currently it looks like this

    Box A

    C:\oracle\oradata\theDatabase\

    I want to move theDatabase directory to Box B

    Example

    Q:\myDatabases\theDatabase

    How do I go about doing that?

    Thanks again for your help.

    Sean
    Last edited by seanmmcc; 11-04-2005 at 02:44 PM. Reason: added more detail.

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