Oracle KUPU$UTILITIES_INT
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 DataPump utilities
AUTHID DEFINER
Dependencies
DBMS_ASSERT DBMS_TTS KUPUTIL
DBMS_DATAPUMP KUPCC KUPV$FT_INT
DBMS_DATAPUMP_UTL KUPF$FILE KUPW$WORKER
DBMS_LOCK KUPF$FILE_INT PLITBLM
DBMS_METADATA KUPM$MCP V_$PARAMETER
DBMS_METADATA_DIFF KUPP$PROC X$KSPPCV
DBMS_METADATA_UTIL KUPU$UTILITIES X$KSPPI
DBMS_PLUGTS KUPULIB  
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
 
CHECK_ENCRYPTION_WALLET
Undocumented kupu$utilities_int.check_encryption_wallet;
exec kupu$utilities_int.check_encryption_wallet;
BEGIN kupu$utilities_int.check_encryption_wallet; END;
*
ERROR at line 1:
ORA-28365: wallet is not open
ORA-06512: at "SYS.KUPU$UTILITIES_INT", line 94
ORA-06512: at line 1
 
CHECK_IF_SHARDED_DB
Undocumented kupu$utilities_int.check_if_sharded_db RETURN NUMBER;
SELECT kupu$utilities_int.check_if_sharded_db
FROM dual;

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('c:\u21');
BEGIN kupu$utilities_int.create_directory('c:\u21'); END;
      *
ERROR at line 1:
ORA-06550: line 1, column 7:
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
FROM dual;

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')
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
FROM dual;
SELECT kupu$utilities_int.get_dp_update_lock
       *
ERROR at line 1:
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')
FROM dual;
SELECT kupu$utilities_int.get_parameter_value('db_securefile')
       *
ERROR at line 1:
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
 
GPD_IMP_ALLOWED
Undocumented

Protected by an Accessible By clause
kupu$utilities_int.gpd_imp_allowed RETURN BINARY_INTEGER;
SELECT kupu$utilities_int.gpd_imp_allowed
FROM dual;
SELECT kupu$utilities_int.gpd_imp_allowed
       *
ERROR at line 1:
ORA-06553: PLS-904: insufficient privilege to access object GPD_IMP_ALLOWED
 
INTALGCONV
Undocumented kupu$utilities_int.intalgconv(
alg     IN  BINARY_INTEGER,
in_val  IN  VARCHAR2,
out_val OUT VARCHAR2);
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
FROM dual;
SELECT kupu$utilities_int.max_datapump_jobs_per_pdb
*
ERROR at line 1:
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);
 
TEN_G_LOGON_ALLOWED
Undocumented kupu$utilities_int.ten_g_logon_allowed RETURN NUMBER;
SELECT kupu$utilities_int.ten_g_logon_allowed
FROM dual;

TEN_G_LOGON_ALLOWED
-------------------
                  0
 
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

Related Topics
Built-in Functions
Built-in Packages
Database Security
KUPU$UTILITIES
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