Streams Synchronous Capture 11g New Feature Example
(Doc ID 1109293.1)
Last updated on DECEMBER 18, 2023
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [Release 11.1 to 11.2]
Oracle Database Cloud Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Information in this document applies to any platform.
Minimal patches that needs to be applied before configuring Streams Streams Specific Patches (Doc ID 437838.1)
10gR2 Streams Recommended Configuration (Doc ID 418755.1)
Streams Synchronous Capture is a New Feature of Oracle 11g; It doesn't rely on archive logs
or redo logs to capture changes. Instead a synchronous capture uses an internal mechanism to
capture changes and format each captured change into an LCR. The messages captured by a synchronous capture
are called persistent LCRs. A synchronous capture always enqueues into a commit-time queue
to ensure that transactions are ordered properly.
- TIMESTAMP WITH TIME ZONE
- TIMESTAMP WITH LOCAL TIME ZONE
- INTERVAL YEAR TO MONTH
- INTERVAL DAY TO SECOND
A synchronous capture cannot have a negative rule set.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document