Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Moving D.B. to diff. drive

Re: Moving D.B. to diff. drive

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Fri, 21 Mar 2003 15:22:54 +0800
Message-ID: <3E7ABDCE.7CE2@yahoo.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US