The unsupported datatypes are:
- 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:
| No Format |
|---|
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):
| No Format |
|---|
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'); |