Re: I need to move one datafile from one directory to another

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Tue, 21 Sep 1999 18:32:57 GMT
Message-ID: <37E7CF59.488F8EE8@edcmail.cr.usgs.gov>

Try this:

Take the tablespace that uses the datafile offline. ALTER TABLESPACE ts_name OFFLINE;
Move the datafile with OS commands.
Rename the datafile in Oracle. ALTER TABLESPACE ts_name RENAME DATAFILE old_fn TO new_fn;
Bring tablespace back online. ALTER TABLESPACE ts_name ONLINE;

HTH,
Brian

srana5190_at_my-deja.com wrote:
>
> I do like to move one datafile of oracle from one directory to another.
> What I have to do so that I can reallocte the datafiles place.
>
> Thanks advance for your reply
>
> Sohail
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Tue Sep 21 1999 - 13:32:57 CDT