If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

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.

1) take a backup
2) create a service on the new windows box and start it
3) alter database backup controlfile to trace;
4) shutdown the original db
5) move it to the new box in the locations you want
6) edit the pfile with the parameters for the control file locations / dump directories
7) take the trace file made before, remove all the crap and change the locations of all files using find / replace
8) run the file in sqlplus
9) live long and enjoy

That will save you a lot of time instead of manully moving all files in the data dictionary

it appears you guys are responding without having having understood what he wants..here is it as he states it...
"davey23uk, i want to keep the oracle server on box 'A' i just want to move all the files to a directory on box 'B'. And then tell oracle on box 'A' that all the files have moved."
-he only wants to move oracle files to box B.
-then link/tell Oracle that the files are on box B
-there is no oracle software on box B
-he doesn't want to intall oralce on box B