Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Moving D.B. to diff. drive
Kevin wrote:
>
> Thank you in advance,
> I need to relocate my database files from drive "c" to drive "e"
> (space concerns, same server - NT4) Can I just move them to there new
> location and update the path in the Oracle storage manager? Oracle
> version is 8i. Anything else?
> Thanks much,
> Kevin
Dunno if OEM will do this for you but the basic steps are:
alter tablespace XXX offline
(move the datafiles for tablespace XXX)
alter database rename file 'oldfile' to 'newfile'
alter tablespace XXX online
hth
connor
-- ========================= Connor McDonald http://www.oracledba.co.uk "Some days you're the pigeon, some days you're the statue"Received on Fri Mar 21 2003 - 01:22:54 CST