Streams Capture of Sequence Value (Doc ID 393710.1)

Last updated on MAY 08, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 and later
Information in this document applies to any platform.

Goal

We are planning to create a table with id that is populated with NEXTVAL using
trigger whenever record is inserted.

1) Does the records inserted with get replicated without any issues ?
2) What about the sequence will it get replicated ?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms