-
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 03: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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|