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');
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');