📋Steps in this guide1/1

Move LOB segment to another tablespace

-- Find the lob segment details

oracle configurationintermediate

by OracleDba

14 views

Move LOB segment to another tablespace

-- Find the lob segment details -- Move to new tablespace

Code/Command (click line numbers to comment):

1
2

select table_name,COLUMN_NAME,SEGMENT_NAME,TABLESPACE_NAME from dba_lobs where OWNER='DBACLASS'
alter table DBACLASS.LOB_SEG1 move lob (PAYLOAD) store as SYS_LOB0000100201C00011$$ ( tablespace USERS);

Comments (0)

Please to add comments

No comments yet. Be the first to comment!