The unsupported Unsupported datatypes are:
- BINARY_FLOAT
- BINARY_DOUBLE
- TIMESTAMP WITH TIMEZONE (TZR) and (TZD)*
- 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'); |
- Some SECUREFILE LOBs operations (see below)
- 32K VARCHAR (Oracle 12.1)
- identity columns (Oracle 12c)
*TIMESTAMP with TIMEZONE expressed as offsets are supported.
If SOURCE tables are created & configured with Oracle Basic Compress option (including at the tablespace level) replication is unsupported for these objects.
A SQL query can be run to determine if there are any datatypes that will not be supported by Dbvisit Replicate.