Functionality Currently NOT Supported

Functionality Currently NOT Supported

The following functionality is currently not supported:

  • Table cluster related DDL.

  • Switchover/failover/flashback.

  • No support for encrypted data (Transparent Data Encryption TDE).

  • No support for compressed data. 

  • External tables

  • Nested tables 

  • NOLOGGING  - if it is not in the redo, it's not replicated. 

  • LOBs with CTAS (create table as select) or direct insert (that's e.g. the APPEND hint, or sqlldr with direct=yes)

The following script will check to see if the tables are clustered:

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, cluster_name, iot_name, iot_type from sys.dba_tables where (cluster_name is not null and owner = upper('&owner') and table_name like upper('&table_name');