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