Non-supported Objects and Operations in Oracle DML (Classic)

The following are not supported in classic capture:

  • Exadata Hybrid Columnar Compression

  • Capture from tables with OLTP table compression

  • Capture from tablespaces and tables created or altered with COMPRESS

  • Capture from encrypted and compressed clustered tables

  • Invisible column

  • Distributed transactions. In Oracle versions 11.1.0.6 and higher, you can capture these transactions if you make them non-distributed by using the following command, which requires the database to be restarted.

    alter system set _CLUSTERWIDE_GLOBAL_TRANSACTIONS=FALSE;
    
  • RAC distributed XA and PDML distributed transactions

  • Version enabled-tables

    Also see Non-supported Objects and Operations in Oracle DML.