Oracle DBMS_STREAMS_DATAPUMP_UTIL
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 DEFINER
Dependencies
DBMS_AQADM_SYS DBMS_LOGREP_IMP KU$_PARAMVALUE1010
DBMS_AQ_IMP_INTERNAL DBMS_STREAMS_DATAPUMP KU$_PARAMVALUES
DBMS_AQ_SYS_EXP_ACTIONS DBMS_STREAMS_MT KU$_STATUS
DBMS_AQ_SYS_EXP_INTERNAL DBMS_STREAMS_PUB_RPC PLITBLM
DBMS_DATAPUMP KU$_JOBDESC V$DATABASE
DBMS_LOGREP_EXP KU$_PARAMVALUE _DBA_APPLY_SOURCE_SCHEMA
Documented No
First Available Not known
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvthsdp.plb
Subprograms
GET_RMAN_INST_SCN IS_MAINTAIN_DATAPUMP JOB_TYPE
GET_TYPE_NUM IS_STREAMS_CONFIGURATION MIN_SUPP_LOGGING_ENABLED
IN_DATAPUMP_JOB JOB_MODE REMOTE_LINK
IS_FULL_DB_EXPORT    
 
GET_RMAN_INST_SCN
Undocumented dbms_streams_datapump_util.get_rman_inst_scn RETURN NUMBER;
SELECT dbms_streams_datapump_util.get_rman_inst_scn
FROM dual;

GET_RMAN_INST_SCN
-----------------
 
 
GET_TYPE_NUM
Undocumented dbms_streams_datapump_util.get_type_num(canon_type IN VARCHAR2) RETURN NUMBER;
SELECT dbms_streams_datapump_util.get_type_num('VARCHAR2')
FROM dual;
SELECT dbms_streams_datapump_util.get_type_num('VARCHAR2')
       *
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 87
ORA-06512: at "SYS.DBMS_STREAMS_DATAPUMP_UTIL", line 102
 
IN_DATAPUMP_JOB
Undocumented dbms_streams_datapump_util.in_datapump_job RETURN BOOLEAN;
BEGIN
  IF dbms_streams_datapump_util.in_datapump_job THEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
  END IF;
END;
/
F

PL/SQL procedure successfully completed.
 
IS_FULL_DB_EXPORT
Undocumented dbms_streams_datapump_util.is_full_db_export RETURN BOOLEAN;
BEGIN
  IF dbms_streams_datapump_util.is_full_db_export THEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
  END IF;
END;
/
BEGIN
*
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 46
ORA-06512: at line 2
 
IS_MAINTAIN_DATAPUMP
Undocumented dbms_streams_datapump_util.is_maintain_datapump RETURN BOOLEAN;
BEGIN
  IF dbms_streams_datapump_util.is_maintain_datapump THEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
  END IF;
END;
/
BEGIN
*
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 72
ORA-06512: at line 2
 
IS_STREAMS_CONFIGURATION
Undocumented dbms_streams_datapump_util.is_streams_configuration RETURN BOOLEAN;
BEGIN
  IF dbms_streams_datapump_util.is_streams_configuration THEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
  END IF;
END;
/
BEGIN
*
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 30
ORA-06512: at "SYS.DBMS_STREAMS_DATAPUMP_UTIL", line 60
ORA-06512: at line 2
 
JOB_MODE
Undocumented dbms_streams_datapump_util.job_mode RETURN VARCHAR2;
SELECT dbms_streams_datapump_util.job_mode
FROM dual;
SELECT dbms_streams_datapump_util.job_mode
       *
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 87
 
JOB_TYPE
Undocumented dbms_streams_datapump_util.job_type RETURN VARCHAR2;
SELECT dbms_streams_datapump_util.job_type
FROM dual;
SELECT dbms_streams_datapump_util.job_type
*
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
 
MIN_SUPP_LOGGING_ENABLED
The name would lead a reasonable person to conclude that running checks to see if MIN supplemental logging is enabled ... that is clearly not what it does.

Perhaps "MIN" means minimum required with respect to the functionality of Streams DataPump.		 dbms_streams_datapump_util.min_supp_logging_enabled RETURN BOOLEAN;
SELECT supplemental_log_data_min, supplemental_log_data_pk, supplemental_log_data_ui
FROM v$database;

SUPPLEME SUP SUP
-------- --- ---
NO       NO  NO

BEGIN
  IF dbms_streams_datapump_util.min_supp_logging_enabled THEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
  END IF;
END;
/
T

PL/SQL procedure successfully completed.

SELECT supplemental_log_data_min, supplemental_log_data_pk, supplemental_log_data_ui,
supplemental_log_data_fk, supplemental_log_data_all, supplemental_log_data_pl, supplemental_log_data_sr
FROM v$database;

SUPPLEME SUP SUP SUP SUP SUP SUP
-------- --- --- --- --- --- ---
IMPLICIT YES YES NO  NO  YES NO
 
REMOTE_LINK
Undocumented dbms_streams_datapump_util.remote_link RETURN VARCHAR2;
SELECT dbms_streams_datapump_util.remote_link
FROM dual;
SELECT dbms_streams_datapump_util.remote_link
*
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 94

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_DATAPUMP
DBMS_STREAMS_DATAPUMP
What's New In 21c
What's New In 23c

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-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx