Page Comparison

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

• XMLType.
• Table cluster related DDL.IOTs (index-organized tables).
• Switchover/failover/flashback.
• Non-standard redo log block size (including 4k on 11gR2 on Advanced Format disks).
• Object datatypes (includes ADT, VARRAY, nested tables etc.).
• SDO_GEOMETRY datatype.
• Only English version is available. Different languages will be supported in the future.
• No support for compression or encrypted data (Transparent Data Encryption TDE).

Known limitation:

• Dbvisit Replicate relies on the target database client settings for handling of NLS issues. For an Oracle target database, set the NLS_LANG environment variable to "AMERICAN_AMERICA.source_db_charset". The AMERICAN_AMERICA part ensures unified number and date formats and specifying the source database charset ensures that the client libraries handle any non-ASCII characters properly.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');