Quote Originally Posted by seanmmcc
Hi,

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
Shutdown immediate;
startup mount;
##move your db files from A to B physically##
ALTER DATABASE RENAME FILE 'C:\oracle\oradata\theDatabase\
' to 'Q:\myDatabases\theDatabase';#rename all the moved files
alter database open;
Alter database backup controlfile to '/...../..../../';
Alter database backup controlfile to trace;
## take a complete backup(if archive log mode)hot/RMAN, or shutdown again and take a cold backup if no archive log mode##
Startup

Goodluck