Page Comparison

-- find_identity_col.sql
--

ttitle left '*****  12c Tables that have an identity feature column *****' skip 2
btitle off
set linesize 150
column owner format A40
column table_name format A40
column column_name format A40

spool identity.txt

select owner, table_name, column_name 
from ALL_TAB_IDENTITY_COLS 
where owner not in (
'XDB','SYS','SYSTEM','SYSMAN','WMSYS','OLAPSYS','MDSYS','APEX_030200',
'FLOWS_FILES','EXFSYS','APPQOSSYS','CTXSYS','ORDDATA','OUTLN','DBSNMP',
'ORDSYS','DBVREP','APEX_040200','LBACSYS')
and table_name not like 'BIN%'
order by 1,2,3;

spool off;