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 will be available on generic Linux platforms in January and soon on AIX and Windows

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