Supported Objects and Operations for SQL/MX

The objects and operations supported by Oracle GoldenGate for SQL/MX are:

• Oracle GoldenGate supports the extraction and replication of DML operations on tables that contain rows of up to 512 KB in length.

• Oracle GoldenGate supports the maximum number and size of columns per table that is supported by the database.

• Updates to primary keys are supported for SQL/MX version 3.2 and later.

• PURGEDATA operations

• SQL/MX now generates heartbeat records.

  Note:

  For other source GoldenGate versions higher than relelase 12.2, that send data to Oracle GoldenGate SQL/MX, the Extract on the source should use the option FORMAT RELEASE 12.2 for EXTTRAIL/RMTTRAIL parameter.

  Limitations on Automatic Heartbeat Table support are as follows:

  • The GLOBALS heartbeat table only supports two-part and three-part names. You can use ENABLECATALOGNAMES to enable these table names.

  • Do not use the Oracle GoldenGate default schema, GGSCHEMA; you must use a two or three-part name only.