Find tables with LOB seg in DB - Oracle Database Script.
SET pagesize 200
SET lines 200
SET long 999 col OWNER
FOR a15 col TABLE_NAME
FOR a20 col COLUMN_NAME
FOR a21
SELECT a.owner,
a.table_name,
a.column_name,
data_type
FROM dba_lobs a,
dba_tab_columns b
WHERE a.column_name=b.column_name
AND a.table_name = b.table_name
AND a.owner = b.owner
AND b.owner NOT IN ('SYS',
'SYSTEM',
'DBSNMP',
'WMSYS');