Oracle | DBMS_STREAMS

Oracle DBMS_STREAMS_DATAPUMP Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Undocumented

AUTHID CURRENT_USER

Dependencies

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

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;

      /

      DECLARE

      *

      ERROR at line 1:

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

      ORA-06512: at "SYS.DBMS_DATAPUMP", line 4747

      ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79

      ORA-06512: at "SYS.DBMS_DATAPUMP", line 4494

      ORA-06512: at "SYS.DBMS_DATAPUMP", line 5973

      ORA-06512: at "SYS.DBMS_STREAMS_DATAPUMP_UTIL", line 18

      ORA-06512: at "SYS.DBMS_STREAMS_DATAPUMP_UTIL", line 80

      ORA-06512: at "SYS.DBMS_STREAMS_DATAPUMP", line 428

      ORA-06512: at line 4

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;

      /

      DECLARE

      *

      ERROR at line 1:

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

      ORA-06512: at "SYS.DBMS_DATAPUMP", line 4747

      ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79

      ORA-06512: at "SYS.DBMS_DATAPUMP", line 4494

      ORA-06512: at "SYS.DBMS_DATAPUMP", line 5973

      ORA-06512: at "SYS.DBMS_STREAMS_DATAPUMP_UTIL", line 18

      ORA-06512: at "SYS.DBMS_STREAMS_DATAPUMP_UTIL", line 80

      ORA-06512: at "SYS.DBMS_STREAMS_DATAPUMP", line 219

      ORA-06512: at line 5

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.