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);