moving lob object to other tablespace lob_mvmt.sql

set lines 132

set pagesize 3000

spool lob_mvmt

select ‘alter table ‘ || table_name || ‘ move lob(‘|| column_name || ‘) store as ( tablespace pnet_data ) ;’

from user_tab_columns

where data_type like ‘%LOB%’;

spool off