Versions Compared

Old Version 6

changes.mady.by.user Chris Lawless (Deactivated)

Saved on

compared with

New Version Current

changes.mady.by.user Donna Zehl (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
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_DICOMSECUREFILE LOBs

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

Section
Column
width5%

 

Column
width95
Panel
bgColorCCC
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):

Section
Column
width5%

 

Column
width95
Panel
bgColorCCC
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.