Home

Description

Starting from Oracle Database 19c, the DBMS_STREAMS_ADM package is desupported. Oracle Streams replication functionality is no longer available, and all operations relying on this package will fail if not migrated.

Oracle recommends transitioning to Oracle GoldenGate for replication and data synchronization tasks as it offers better performance, cross-version support, and enhanced reliability.

Identify and replace all DBMS_STREAMS_ADM references in your code with equivalent GoldenGate configurations and replication strategies.

Key Benefits

• Future Proofing: Ensures your database replication solutions are supported in Oracle 19c and later versions.
• Reliability: GoldenGate offers superior replication features compared to the deprecated Streams technology.
• Maintainability: Simplifies management by using an actively maintained and supported replication solution.

Non-compliant Code Example

BEGIN
  DBMS_STREAMS_ADM.ADD_TABLE_RULES(                 --Non compliant code (DBMS_STREAMS_ADM package is desupported)
    table_name     => 'HR.EMPLOYEES',
    streams_type   => 'CAPTURE',
    streams_name   => 'capture_stream',
    queue_name     => 'stream_queue'
  );
END;