Oracle | KUPU$UTILITIES

Oracle KUPU$UTILITIES_INT Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose DataPump utilities

AUTHID DEFINER

Data Types TYPE t_traceentries ....

Dependencies

DBMS_ASSERT	DBMS_TTS	KUPULIB
DBMS_DATAPUMP	DBMS_UTILITY	KUPUTIL
DBMS_DATAPUMP_UTL	KUPCC	KUPV$FT
DBMS_LOCK	KUPF$FILE	KUPV$FT_INT
DBMS_METADATA	KUPF$FILE_INT	KUPW$WORKER
DBMS_METADATA_DIFF	KUPM$MCP	PLITBLM
DBMS_METADATA_INT	KUPP$PROC	X$KSPPCV
DBMS_METADATA_UTIL	KUPU$UTILITIES	X$KSPPI
DBMS_PLUGTS

Documented No

Exceptions

Error Code	Reason
ORA-28365	wallet is not open

First Available 12.1

Security Model Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role

Direct access to some objects in this package is prevented by means of an Accessible By clause.

Source {ORACLE_HOME}/rdbms/admin/prvthpui.plb
{ORACLE_HOME}/rdbms/admin/prvtbpui.plb

Subprograms

CALL_STATS_SET_TRACE	DH_GEN_SHARED_KEY	IS_SUPERSET
CHECK_ENCRYPTION_WALLET	DH_GET_PUBLIC_KEY	MAX_DATAPUMP_JOBS_PER_PDB
CHECK_IF_SHARDED_DB	DH_NEW_HANDLE	RELEASE_DP_UPDATE_LOCK
CHECK_IGNORE_DESC_IN_INDEX	DIRECTORY_SCAN	SET_DEBUG
CHECK_TBS_FOR_TDECOL_TABS	ENCODE	SET_KGL_TIME_TO_WAIT_FOR_LOCKS
CREATE_DIRECTORY	GET_DP_UPDATE_LOCK	TEN_G_LOGON_ALLOWED
DEBUG	GET_PARAMETER_VALUE	TRACE_DUMP
DECODE	GET_REMOTE_DBLINK_USER	TRACE_FREE
DH_CHECK_DIGESTS	GET_SESSION_STAT	TRACE_GET
DH_DECRYPT	GET_SHARDED_TABLE_FAMILY_ID	TRACE_WRITE
DH_ENCRYPT	INTALGCONV	UPDATEFEATURETABLE
DH_FREE_HANDLE	INT_CHECK_IF_SHARDED_DB	WRITEAUDITRECORD

CALL_STATS_SET_TRACE (new 23ai)

Undocumented kupu$utilities_int.call_stats_set_trace;

exec kupu$utilities_int.call_stats_set_trace;

          *

      PLS-00904: insufficient privilege to access object CALL_STATS_SET_TRACE

CHECK_ENCRYPTION_WALLET

Undocumented kupu$utilities_int.check_encryption_wallet;

exec kupu$utilities_int.check_encryption_wallet;

           *

      ORA-28365: wallet is not open

CHECK_IF_SHARDED_DB

Undocumented kupu$utilities_int.check_if_sharded_db RETURN NUMBER;

SELECT kupu$utilities_int.check_if_sharded_db;

      

      CHECK_IF_SHARDED_DB

      -------------------

CHECK_IGNORE_DESC_IN_INDEX

Undocumented kupu$utilities_int.check_ignore_desc_in_index RETURN BOOLEAN;

BEGIN

        IF kupu$utilities_int.check_ignore_desc_in_index THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      F

      

      PL/SQL procedure successfully completed.

CHECK_TBS_FOR_TDECOL_TABS

Undocumented kupu$utilities_int.check_tbs_for_TDEcol_tabs( mt IN VARCHAR2, dblink IN VARCHAR2) RETURN NUMBER;

TBD

CREATE_DIRECTORY

Undocumented

Protected by an Accessible By clause kupu$utilities_int.create_directory(dir_path IN VARCHAR2);

exec kupu$utilities_int.create_directory('/u03');

           *

      PLS-00904: insufficient privilege to access object CREATE_DIRECTORY

DEBUG

Undocumented kupu$utilities_int.debug(str IN VARCHAR2);

TBD

DECODE

Undocumented kupu$utilities_int.decode(src IN VARCHAR2) RETURN VARCHAR2;

TBD

DH_CHECK_DIGESTS

Undocumented kupu$utilities_int.dh_check_digests( handle IN NUMBER, srcdigest IN VARCHAR2, tardigest IN VARCHAR2);

TBD

DH_DECRYPT

Undocumented kupu$utilities_int.dh_decrypt( handle IN NUMBER, srcbuf IN VARCHAR2, outfmt IN BINARY_INTEGER) RETURN VARCHAR2;

TBD

DH_ENCRYPT

Undocumented kupu$utilities_int.dh_encrypt( handle IN NUMBER, srcbuf IN VARCHAR2, inpfmt IN BINARY_INTEGER) RETURN VARCHAR2;

TBD

DH_FREE_HANDLE

Undocumented kupu$utilities_int.dh_free_handle(handle IN NUMBER);

TBD

DH_GEN_SHARED_KEY

Undocumented kupu$utilities_int.dh_gen_shared_key( handle IN NUMBER, pubkey IN VARCHAR2) RETURN VARCHAR2;

TBD

DH_GET_PUBLIC_KEY

Undocumented kupu$utilities_int.dh_get_public_key(handle IN NUMBER) RETURN VARCHAR2;

TBD

DH_NEW_HANDLE

Undocumented kupu$utilities_int.dh_new_handle RETURN NUMBER;

SELECT kupu$utilities_int.dh_new_handle;

      

      DH_NEW_HANDLE

      -------------

DIRECTORY_SCAN

Undocumented kupu$utilities_int.directory_scan( infilespec IN VARCHAR2, indefdirspec IN VARCHAR2, inskipfileverify IN BOOLEAN, insubdirsearch IN BOOLEAN, outhaswildcard OUT BOOLEAN, inplsqlarray IN OUT public.kuputil.t_datafile_names, inarrayindex IN BINARY_INTEGER) RETURN BINARY_INTEGER;

TBD

ENCODE

Undocumented kupu$utilities_int.encode(src IN VARCHAR2) RETURN VARCHAR2;

SELECT kupu$utilities_int.encode('SELECT * FROM dual');

      

      KUPU$UTILITIES_INT.ENCODE('SELECT*FROMDUAL')

      --------------------------------------------

GET_DP_UPDATE_LOCK

Undocumented

Protected by an Accessible By clause kupu$utilities_int.get_dp_update_lock RETURN VARCHAR2;

SELECT kupu$utilities_int.get_dp_update_lock;

             *

      ORA-06553: PLS-904: insufficient privilege to access object GET_DP_UPDATE_LOCK

GET_PARAMETER_VALUE

Undocumented

Protected by an Accessible By clause kupu$utilities_int.get_parameter_value(name IN VARCHAR2) RETURN VARCHAR2;

SELECT kupu$utilities_int.get_parameter_value('db_securefile');

             *

      ORA-06553: PLS-904: insufficient privilege to access object GET_PARAMETER_VALUE

GET_REMOTE_DBLINK_USER

Undocumented kupu$utilities_int.get_remote_dblink_user( userid IN NUMBER, link_name IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_SESSION_STAT

Undocumented kupu$utilities_int.get_session_stat( statistic IN VARCHAR2, sid IN NUMBER) RETURN NUMBER;

TBD

GET_SHARDED_TABLE_FAMILY_ID

Undocumented kupu$utilities_int.get_sharded_table_family_id( schemaname IN VARCHAR2, tablename IN VARCHAR2) RETURN NUMBER;

TBD

INTALGCONV

Undocumented kupu$utilities_int.intalgconv( alg IN BINARY_INTEGER, in_val IN VARCHAR2, out_val OUT VARCHAR2);

TBD

INT_CHECK_IF_SHARDED_DB (new 23ai)

Undocumented kupu$utilities_int.int_check_if_sharded_db RETURN NUMBER;

TBD

IS_SUPERSET

Undocumented kupu$utilities_int.is_superset( frcsid IN BINARY_INTEGER, tocsid IN BINARY_INTEGER) RETURN BOOLEAN;

TBD

MAX_DATAPUMP_JOBS_PER_PDB

Undocumented

Protected by an Accessible By clause kupu$utilities_int.max_datapump_jobs_per_pdb RETURN BINARY_INTEGER;

SELECT value

      FROM v$parameter

      WHERE name = 'max_datapump_jobs_per_pdb';

      

      VALUE

      -----

       
      100

      

      SELECT
      kupu$utilities_int.max_datapump_jobs_per_pdb;

            
      *

      ORA-06553: PLS-904: insufficient privilege to access object MAX_DATAPUMP_JOBS_PER_PDB

RELEASE_DP_UPDATE_LOCK

Undocumented kupu$utilities_int.release_dp_update_lock(swlock_handle IN VARCHAR2);

TBD

SET_DEBUG

Undocumented kupu$utilities_int.set_debug(debug_flags IN BINARY_INTEGER);

exec kupu$utilities_int.set_debug(0);

SET_KGL_TIME_TO_WAIT_FOR_LOCKS (new 23ai)

Undocumented kupu$utilities_int.set_kgl_time_to_wait_for_locks(lwait_time IN NUMBER);

TBD

TEN_G_LOGON_ALLOWED

Undocumented kupu$utilities_int.ten_g_logon_allowed RETURN NUMBER;

SELECT kupu$utilities_int.ten_g_logon_allowed;

      

      TEN_G_LOGON_ALLOWED

      -------------------

                        0

TRACE_DUMP (new 23ai)

Undocumented kupu$utilities_int.trace_dump(banner_ident IN VARCHAR2);

TBD

TRACE_FREE (new 23ai)

Undocumented kupu$utilities_int.trace_free;

TBD

TRACE_GET (new 23ai)

Undocumented kupu$utilities_int.trace_get( last_n IN NUMBER, entries OUT sys.kupu$utilities_int.t_traceentries);

TBD

TRACE_WRITE (new 23ai)

Undocumented kupu$utilities_int.trace_write( trace_message IN VARCHAR2, trace_options IN NUMBER);

TBD

UPDATEFEATURETABLE

Undocumented kupu$utilities_int.updateFeatureTable( utility_name IN VARCHAR2, feature_info IN public.kuputil.feature_info_t);

TBD

WRITEAUDITRECORD

Undocumented kupu$utilities_int.writeAuditRecord( action IN BINARY_INTEGER, master_only IN BOOLEAN, data_only IN BOOLEAN, metadata_only IN BOOLEAN, dumpfile_present IN BOOLEAN, job_restarted IN BOOLEAN, master_tabname IN VARCHAR2, meta_job_mode IN VARCHAR2, job_version IN VARCHAR2, access_method IN VARCHAR2, data_options IN VARCHAR2, dumper_directory IN VARCHAR2, remote_link IN VARCHAR2, table_exists_action IN VARCHAR2, partition_options IN VARCHAR2);

TBD