Non-Supported Objects and Operations for SQL/MX

The objects and operations that Oracle GoldenGate does not support for SQL/MX are:

  • Extraction or replication of DDL (data definition language) operations

  • Oracle GoldenGate SQLEXEC functionality not supported in Extract.

  • Oracle GoldenGate parameters that involve fetching from the database, such as FETCHCOLS, FETCHCOLSEXCEPT, and FETCHBEFOREFILTER.

  • NonStop SQL/MX distributed transactions

  • Views

  • Datatypes

    • BINARY

    • VARBINARY