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
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.

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_DATAPUMP
DBMS_FLASHBACK
DBMS_INTERNAL_SAFE_SCN
DBMS_STREAMS_DATAPUMP_UTIL
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx