Supported Objects and Operations

Following are the operations that are supported with Google Spanner, in the current release:

• Classic and Coordinated Replicat types are supported when using Google Cloud Spanner.

• Insert, Update, Delete, Truncate operations are supported. Truncate operation is supported with Replicat parameter GETTRUNCATES.

• Unified updates using UPDATERECORDFORMAT FULL | COMPACT are supported.

• Heartbeat table support is provided in Google Spanner to create only the heartbeat objects on the target. However, Google spanner does not have the background schedular jobs, so the heartbeat commands do not create a scheduler job for updating the heartbeat table or purging the heartbeat history. Heartbeat records are only replicated from the source to the target to monitor replication lag from the source. See Limitations and Non-Supported Objects and Operations to know about the limitations of this support.

• Globalization Support is available in Oracle GoldenGate Replicat for Google Cloud Spanner.

• Character Conversion in column data is supported.

• REPERROR, HANDLECOLLISIONS, INSERTMISSINGUPDATES parameters are supported.

• If the table name specified in the Replicat map statement is unqualified implying that the table name is specified without the schema name, then the schema name is taken from GGSCHEMA in GLOBALS. If GGSCHEMA is not specified, then Replicat uses the default (unnamed) schema in Google Cloud Spanner.