Oracle KUPU$UTILITIES_INT
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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 19c
What's New In 20c-21c

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