Page Comparison

• BINARY FLOAT
• BINARY_DOUBLE
• ROWID
• UROWID
• ANYDATA
• ANYTYPE
• ANYDATASET
• XMLTYPE
• URITYPE
• SDO_GEOMETRY
• SDO_GEORASTER
• SDO_TOPO_GEOMETRY
• ORD_DICOM
• SECUREFILE LOBs
  
  

The following script can help determine if the tables in your schema contain unsupported datatypes:

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.

select owner, table_name, column_name, data_type 

from sys.dba_tab_cols 

where data_type not in (

 'NUMBER',

 'FLOAT',

 'VARCHAR2',

 'VARCHAR',

 'CHAR',

 'NVARCHAR2',

 'NCHAR',

 'NCHAR2',

 'LONG',

 'LONG RAW',

 'DATE',

 'RAW',

 'BFILE',

 'CLOB',

 'BLOB',

 'NCLOB'

)

and data_type not like 'INTERVAL%'

and data_type not like 'TIMESTAMP%'

and owner = upper('&owner')

and table_name like upper('&table_name');

Unsupported LOB options (11g SecureFiles):

select owner, table_name, column_

name 
from dba_

lobs 
where encrypt not in ('NO','NONE')

or compression not in ('NO','NONE')

or deduplication not in ('NO','NONE');