RE: transfer Tablespace

From: Freeman, Donald <dofreeman_at_state.pa.us>
Date: Fri, 19 Mar 2004 13:36:51 -0500
Message-ID: <AFF54B073FF15849B53E32E67EE860763A9324@ENHBGPRI11.PA.LCL>

This will work for table and index segments. I created a "REORG" tablespace to hold everything until I rebuilt the source tablespace.

SELECT 'ALTER '||segment_type||' '||owner||'.'||segment_name||' REBUILD TABLESPACE REORG;' FROM dba_segments
WHERE tablespace_name ='TEFL_INDX'
AND SEGMENT_TYPE ='INDEX'; SELECT 'ALTER '||segment_type||' '||owner||'.'||segment_name||' MOVE TABLESPACE REORG;' FROM dba_segments
WHERE tablespace_name ='TEFL_DATA'
AND SEGMENT_TYPE ='TABLE'; I have one table with a blob column: I moved the table as inidicated in the first lline and moved the blob column as indicated in teh second column.

ALTER TABLE TEFL.FREE_FORM_DATA move TABLESPACE TEFL_DATA; ALTER TABLE TEFL.FREE_FORM_DATA move lob(BINARY_DATA) store as ( tablespace TEFL_DATA );

"BINARY_DATA" is the blob column name. You should be able to do both these things with one statement but I couldn't get it to work.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Huascar Espinoza Sent: Friday, March 19, 2004 1:15 PM
To: oracle-l_at_freelists.org
Subject: transfer Tablespace

How can I transfer a database to other Tablespace and datafile without loss data?

Thank you,

Huascar

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

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Fri Mar 19 2004 - 12:33:37 CST