Oracle DBMS_STREAMS

Oracle DBMS_STREAMS_DATAPUMP Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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.