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 database.

Note:

Using sequences requires additional configuration steps within the Oracle Database. See Support for Oracle Sequences and Using Sequences topics in the Oracle GoldenGate Microservices Documentation.

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;