The unsupported datatypes are:
- BINARY FLOAT
- BINARY_DOUBLE
- ROWID
- UROWID
- ANYDATA
- ANYTYPE
- ANYDATASET
- XMLTYPE
- URITYPE
- SDO_GEOMETRY
- SDO_GEORASTER
- SDO_TOPO_GEOMETRY
- ORD_DICOM
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');