Oracle | DBMS_STREAMS_DATAPUMP

Oracle DBMS_STREAMS_DATAPUMP_UTIL 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 DEFINER

Dependencies

DBA_SUPPLEMENTAL_LOGGING	DBMS_LOGREP_EXP	KU$_PARAMVALUE
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	_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;

      

      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');

             *

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

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;

      /

      *

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

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;

      /

      *

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

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;

      /

      *

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

JOB_MODE

Undocumented dbms_streams_datapump_util.job_mode RETURN VARCHAR2;

SELECT dbms_streams_datapump_util.job_mode;

             *

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

JOB_TYPE

Undocumented dbms_streams_datapump_util.job_type RETURN VARCHAR2;

SELECT dbms_streams_datapump_util.job_type;

            
      *

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

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;

             *

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