查询lob对象的表和字段

col owner format a20
col object_id format 99999999
col object_name format a30
col object_type format a30
col column_name format a30
col table_name format a30
set linesize 170

select o.owner,
o.object_id,
o.object_name,
o.object_type,
l.table_name,
l.column_name
from dba_objects o
inner join dba_lobs l
on l.segment_name = o.object_name
and o.owner = l.owner
where o.owner ='CDC_BASE_BYD'
order by 1,2;

select * from dba_lobs where owner='SYS' and table_name='';

select * from dba_objects where object_type='LOB' and owner=' ' and object_name=' ';