RE: Moving tablespace across disks

From: Christopher Spence <cspence_at_FuelSpot.com>
Date: Mon, 25 Jun 2001 11:12:00 -0700
Message-ID: <F001.00336F23.20010625112730@fatcity.com>

To properly move a tablespace you should put it in read only mode so the header is not written to. Copy the data files, bring the tablespace offline, rename the files, bring it online and make it read write. You can do this all while the database is up and running.

"Walking on water and developing software from a specification are easy if both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot

-----Original Message-----
Sent: Monday, June 25, 2001 2:51 PM
To: Multiple recipients of list ORACLE-L

Do I need to make the tablespace READONLY before cpying it to another disk location - ora can I simply - take the file offline - and copy the file across

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Vikas Kawatra
INET: VKawatra_at_innoventry.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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.com
--

Author: Christopher Spence
INET: cspence_at_FuelSpot.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------