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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Huascar Espinoza Sent: Friday, March 19, 2004 1:15 PM To: oracle-l@xxxxxxxxxxxxx Subject: transfer Tablespace How can I transfer a database to other Tablespace and datafile without loss data? Thank you, Huascar