Hi,
I see 2 LOB indexes in a tablespace which I want to drop. But I am unable to find the same in DBA_LOBS table. The details on DBA_LOBS table will help me generate the script for moving the LOB to another tablespace.
ALTER TABLE FILTERS3 MOVE LOB(FILTER_OBJECT) STORE AS ( TABLESPACE LOBTS );
Below are the queries, I fired to check the same.
SELECT SEGMENT_NAME,SEGMENT_TYPE,OWNER,TABLESPACE_NAME FROM DBA_SEGMENTS WHERE TABLESPACE_NAME ='GART_TEMP' AND SEGMENT_TYPE LIKE 'LOB%' ORDER BY 1;
SEGMENT_NAME SEGMENT_TYPE OWNER TABLESPACE_NAME
--------------------------------------------------------------------------------- ------------------ ------------------------------ ------------------------------
SYS_IL0000113037C00005$$ LOBINDEX VISUAL GART_TEMP
SYS_IL0000113037C00009$$ LOBINDEX VISUAL GART_TEMP
SYS_LOB0000113037C00005$$ LOBSEGMENT VISUAL GART_TEMP
SYS_LOB0000113037C00009$$ LOBSEGMENT VISUAL GART_TEMP
SELECT OWNER,TABLE_NAME,COLUMN_NAME,SEGMENT_NAME,TABLESPACE_NAME,INDEX_NAME FROM DBA_LOBS WHERE SEGMENT_NAME IN ('SYS_IL0000113037C00005$$','SYS_IL0000113037C00009$$');
no rows selected.
Are the LOB indexes valid, if yes, How can I move the LOBS to another tablespace?
Regards,
Sam