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.

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;