Oracle | DBMS_STREAMS

Oracle DBMS_STREAMS_DATAPUMP Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose DataPump Utilities Supporting Streams

Streams was deprecated 03-Jan-2018 but this package still exists in 23ai,

AUTHID CURRENT_USER

Dependencies

ALL_CAPTURE_PREPARED_TABLES	DBMS_STANDARD
DBA_CAPTURE_PREPARED_TABLES	DBMS_STREAMS_ADM
DBMS_DATAPUMP	DBMS_STREAMS_DATAPUMP_UTIL
DBMS_FLASHBACK	DBMS_STREAMS_DECL
DBMS_INTERNAL_SAFE_SCN	DBMS_STREAMS_PUB_RPC
DBMS_LOGREP_IMP_INTERNAL	DBMS_STREAMS_RPC
DBMS_LOGREP_UTIL

Documented No

Exceptions

Error Code	Reason
ORA-31623	a job is not attached to this session via the specified handle

First Available Not known

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvthsdp.plb

Subprograms

GET_EXPORT_DML_SCN	NEED_SCN	SET_EXPORT_SCN
GET_EXPORT_DML_SCN_VALUE	NEED_SCN_COMMON	SET_SESSION_STATE

GET_EXPORT_DML_SCN

Undocumented dbms_streams_datapump.get_export_dml_scn( schema IN VARCHAR2, tablename IN VARCHAR2, cookie IN VARCHAR2, flashback_scn IN NUMBER) RETURN NUMBER;

SELECT current_scn FROM v$database;

      

      CURRENT_SCN

      -----------

         63077734

      

      DECLARE

       retVal NUMBER;

      BEGIN

        retVal := dbms_streams_datapump.get_export_dml_scn('C##UWCLASS', 'SERVERS', 'TEST', 63077734);

        dbms_output.put_line(retVal);

      END;

      /

      *

      ORA-31623: a job is not attached to this session via the specified handle

GET_EXPORT_DML_SCN_VALUE

Undocumented

Note: No value was returned by the demo at right. dbms_streams_datapump.get_export_dml_scn_value( schema IN VARCHAR2, tablename IN VARCHAR2, flashback_scn IN NUMBER) RETURN NUMBER;

DECLARE

       retVal NUMBER;

      BEGIN

        retVal := dbms_streams_datapump.get_export_dml_scn_value('C##UWCLASS', 'SERVERS', 63077734);

        dbms_output.put_line(retVal);

      END;

      /

      

      PL/SQL procedure successfully completed.

NEED_SCN

Undocumented dbms_streams_datapump.need_scn( dblink IN VARCHAR2, interest OUT BOOLEAN, cookie IN OUT VARCHAR2);

DECLARE

       intVal  BOOLEAN;

       cookVal dbms_id := 'TEST';

      BEGIN

        dbms_streams_datapump.need_scn('CN01.ORACLEVCN.COM', intVal, cookVal);

        dbms_output.put_line(cookVal);

        IF intVal THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      *

      ORA-31623: a job is not attached to this session via the specified handle

NEED_SCN_COMMON

Undocumented dbms_streams_datapump.need_scn_common( interest OUT BOOLEAN, cookie IN OUT VARCHAR2);

DECLARE

       intVal  BOOLEAN;

       cookVal dbms_id := 'TEST';

      BEGIN

        dbms_streams_datapump.need_scn_common(intVal, cookVal);

        dbms_output.put_line(cookVal);

        IF intVal THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      
      TESTS:47:TEST21DB.SUB07212035450.TESTVCN01.ORACLEVCN.COM:

      F

      

      PL/SQL procedure successfully completed.

SET_EXPORT_SCN

Undocumented dbms_streams_datapump.set_export_scn( schema IN VARCHAR2, name IN VARCHAR2, type IN VARCHAR2, cookie IN VARCHAR2, scn IN NUMBER, original_schema IN VARCHAR2, original_name IN VARCHAR2) RETURN BOOLEAN;

TBD

SET_SESSION_STATE

Undocumented dbms_streams_datapump.set_session_state(cookie IN VARCHAR2);

exec dbms_streams_datapump.set_session_state('TEST');

      

      PL/SQL procedure successfully completed.