How to move a lob segment from one tablespace to another one.

Question

Home

Answered

I have a requirement to move a lob segment from one segment to another.

What is the command and can we do it online.

Thanks

truedba Newbie Asked on July 10, 2017 in Databases.

Add Comment

1 Answer(s)

Admin · Accepted Answer · 2017-07-10 18:38:18

Best answer

Dear,

The command to move lob segment online is :

alter table DBACLASS.FD_BREL_AUDIT move lob (PAYLOAD) store as SYS_LOB0000100201C00011$$ ( tablespace USERS);

The lob segment name can be obtained from dba_lobs table.

select table_name,COLUMN_NAME,SEGMENT_NAME,TABLESPACE_NAME from dba_lobs where table_name=’FD_BREL_AUDIT’;

Regards

Admin Newbie Answered on July 10, 2017.

Add Comment