Page Comparison

The following functionality is currently not supported, but maybe supported in future:

• 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');