RE: move a datafile from a filesystem to another

No, the db does not *have* to be in restricted mode.

Simply offline the tablespace (when no one needs it for some time), use OS level command to copy the file to the new location.

>From SQL as sys or system, issue :

1. alter database rename file 'old file name with full path' to 'new file name with full path';
2. alter database backup controlfile to trace; -- so that you have a trace file in udump with updated list of files, should you need to recreate control files (safety procedure).

Bring the tablespace online.
You can remove the old file.

U R Done.

• Kirti

-----Original Message-----
Sent: Wednesday, May 21, 2003 5:17 PM
To: Multiple recipients of list ORACLE-L

which command do I use to move an oracle datafile from one filesystem to another filesystem? I understand the db is to be up in restrict mode.

TIA

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Leyden, Joseph
  INET: LeydenJ_at_MTA.NET

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).