SEQUENCE

Valid For

Extract

Description

Use the SEQUENCE parameter to capture sequence values from the transaction log. Currently, Oracle GoldenGate supports sequences for the Oracle AI Database.

Note: Using sequences requires additional configuration steps within the Oracle AI Database. See Support for Oracle Sequences and Using Sequences topics in the Oracle GoldenGate Microservices Documentation. Replicating sequences negatively impacts performance and unless it is absolutely necessary, sequences should be put into their own classic replicat for best performance. Replication of system-generated sequences for Identity columns is not supported.

Default

None

Syntax

SEQUENCE [container.]schema.sequence;

[container.]schema.sequence

Specifies the fully qualified name of the source sequence. Include the name of the pluggable database if the source is an Oracle container database.

;

Terminates the SEQUENCE parameter statement.

Example

SEQUENCE hr.employees_seq;