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
I want to move theDatabase directory to Box B
How do I go about doing that?
Thanks again for your help.
Last edited by seanmmcc; 11-04-2005 at 02:44 PM.
Reason: added more detail.