FLUSH SEQUENCE

Use FLUSH SEQUENCE to generate the initial redo log information for sequence in the source database. The Extract retrieves this information when the sequence is updated or in the case of a failover. A record is written to the trail file and this record is then used by Replicat to synchronize the source and target sequences properly.

Syntax

FLUSH SEQUENCE owner.sequence

owner.sequence

The owner and name of a sequence. The schema name cannot be null and is required You can use an asterisk (*) wildcard for the sequence name, but not for the owner name.

Example

FLUSH SEQUENCE ggadmin.seq