Moving Database Files
From: Donald W. Pope II <ii_e_at_thunder.cs.odu.edu>
Date: 1995/04/03
Message-ID: <3lp8ur$pfl_at_xanth.cs.odu.edu>#1/1
Date: 1995/04/03
Message-ID: <3lp8ur$pfl_at_xanth.cs.odu.edu>#1/1
I need to move a database file from one disk to another.
I think I know what I need to do, but I'm hoping someone can
verify these steps:
sqldba> shutdown
Go to OS, and rename file to new disk
sqldba> startup mount aptsprod
sqldba> alter database rename file 'usr1:[x.db]prod1.dbs' to
sqldba> alter database open
I am using Oracle RDBMS 6.0.31.
Thanks,
'usr2:[x.db]prod2.dbs'
Don
Received on Mon Apr 03 1995 - 00:00:00 CEST