Move LOB segment to another tablespace - Oracle Database Script. -- Find the lob segment details select table_name,COLUMN_NAME,SEGMENT_NAME,TABLESPACE_NAME from dba_lobs where OWNER='AODBA' -- Move to new tablespace alter table AODBA.LOB_SEG1 move lob (PAYLOAD) store as SYS_LOB0000100201C00011$$ ( tablespace USERS);
-- Find the lob segment details select table_name,COLUMN_NAME,SEGMENT_NAME,TABLESPACE_NAME from dba_lobs where OWNER='AODBA' -- Move to new tablespace alter table AODBA.LOB_SEG1 move lob (PAYLOAD) store as SYS_LOB0000100201C00011$$ ( tablespace USERS);