
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
"What is past is PROLOGUE"