Oracle | KUPU$UTILITIES

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	DH_FREE_HANDLE	GET_SHARDED_TABLE_FAMILY_ID
CHECK_IF_SHARDED_DB	DH_GEN_SHARED_KEY	GPD_IMP_ALLOWED
CHECK_IGNORE_DESC_IN_INDEX	DH_GET_PUBLIC_KEY	INTALGCONV
CHECK_TBS_FOR_TDECOL_TABS	DH_NEW_HANDLE	IS_SUPERSET
CREATE_DIRECTORY	DIRECTORY_SCAN	MAX_DATAPUMP_JOBS_PER_PDB
DEBUG	ENCODE	RELEASE_DP_UPDATE_LOCK
DECODE	GET_DP_UPDATE_LOCK	SET_DEBUG
DH_CHECK_DIGESTS	GET_PARAMETER_VALUE	TEN_G_LOGON_ALLOWED
DH_DECRYPT	GET_REMOTE_DBLINK_USER	UPDATEFEATURETABLE
DH_ENCRYPT	GET_SESSION_STAT	WRITEAUDITRECORD

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