DanBrother的部落格

-----------------------------------------
-- Finding LOB information
-----------------------------------------
select a.segment_name,a.segment_type,a.tablespace_name,
b.table_name,b.column_name
from user_segments a, user_lobs b
where a.segment_type like 'LOB%'
and a.segment_name = b.segment_name;


-----------------------------------------------------------
--Moving LOB objects into a new TS
-----------------------------------------------------------
alter table <table_name> move lob (<lob_column_name>) store as (tablespace <new_tablespace_name>);