The following functionality is currently not supported:
NOLOGGING hint - This operation does not put the data in the redo log so it is therefore not logged.
APPEND hint- This operation does not put the data in the redo log so it is therefore not logged.
Sqlloader with direct option- This operation does not put the data in the redo log so it is therefore not logged.
LOBs with CTAS (create table as select)
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'); |
*** Oracle to Non Oracle Db target - "Deferrable Constraint Deferred" is not supported with Default Optimistic Commit Replication. A Pessimistic Commit must be used when Deferrable Constraints exists on source table and oracle is not a target database.