Page Comparison

 
Prompt Specify owner for the tables that you want to replicate
Prompt Specify table_name(s) for the tables that you want to replicate. % for all.
column owner format A45
set linesize 200
set pagesize 5000
ttitle left '*****  Unsupported Data Types  *****' skip 2
btitle off
 
spool unsupported.txt
select owner, table_name, column_name, data_type 
from sys.dba_tab_cols 
where data_type not in (
 'NUMBER',
 'FLOAT',
 'VARCHAR2',
 'VARCHAR',
 'CHAR',
 'NCHAR',
 'NVARCHAR2',
 'LONG',
 'LONG RAW',
 'DATE',
 'RAW',
 'BFILE',
 'CLOB',
 'BLOB',
 'NCLOB'
)
and data_type not like 'INTERVAL%'
and data_type not like 'TIMESTAMP%'
and owner not in (
'XDB','SYS','SYSTEM','SYSMAN','WMSYS','OLAPSYS','MDSYS','APEX_030200','FLOWS_FILES',
'EXFSYS','APPQOSSYS','CTXSYS','ORDDATA','OUTLN','DBSNMP','ORDSYS','DBVREP')
and table_name not in (select view_name from dba_views)
order by owner,table_name;
spool off