Oracle | KUPV$FT

Oracle KUPV$FT 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 internal utilities

AUTHID CURRENT_USER

Dependencies

DBMS_APPLICATION_INFO	DBMS_SYS_ERROR	KUPF$FILE_INT
DBMS_ASSERT	DBMS_UTILITY	KUPM$MCP
DBMS_DATAPUMP	KUPC$_JOBINFO	KUPP$PROC
DBMS_INTERNAL_LOGSTDBY	KUPC$_MT_INFO	KUPU$UTILITIES_INT
DBMS_LOGREP_UTIL	KUPC$_MT_INFO_LIST	KUPUTIL
DBMS_METADATA	KUPCC	KUPV$FT_INT
DBMS_METADATA_UTIL	KUPD$DATA	KUPW$WORKER
DBMS_PRIV_CAPTURE	KUPF$FILE	PLITBLM

Documented No

First Available Not known

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

Source {ORACLE_HOME}/rdbms/admin/prvthpv.plb
{ORACLE_HOME}/rdbms/admin/prvtbpv.plb

Subprograms

ATTACH_JOB	FLUSH_TIMINGS	OPEN_JOB
BUILD_COL_LIST	GET_FORMATTED_TIME	RECORD_DELTA_TIMINGS
CREATE_GBL_TEMPORARY_MASTERS	HAS_PRIVS	SET_APPLICATION_ROLE
DP_ATTACH_JOB	MATCH_MT_VERSION	SET_LONGOPS
ERROR_TEXT	MESSAGE_TEXT	START_TIMINGS

ATTACH_JOB

Undocumented kupv$ft.attach_job( user_name IN VARCHAR2, job_name IN VARCHAR2, caller_type IN BINARY_INTEGER, new_job OUT BINARY_INTEGER, ena_sec_roles IN NUMBER) RETURN NUMBER;

TBD

BUILD_COL_LIST

Build column list kupv$ft.build_col_list( table_version IN VARCHAR2, list_type IN VARCHAR2) RETURN VARCHAR2;

TBD

CREATE_GBL_TEMPORARY_MASTERS

Undocumented kupv$ft.create_gbl_temporary_masters;

exec kupv$ft.create_gbl_temporary_masters;

      

      PL/SQL procedure successfully completed.

DP_ATTACH_JOB

Undocumented kupv$ft.dp_attach_job( user_name IN VARCHAR2, job_name IN VARCHAR2, caller_type IN BINARY_INTEGER, new_job OUT BINARY_INTEGER) RETURN NUMBER;

TBD

ERROR_TEXT

Undocumented kupv$ft.error_text( message_num IN NUMBER, parameter1 IN VARCHAR2, parameter2 IN VARCHAR2, parameter3 IN VARCHAR2, parameter4 IN VARCHAR2, parameter5 IN VARCHAR2, parameter6 IN VARCHAR2, parameter7 IN VARCHAR2, parameter8 IN VARCHAR2) RETURN VARCHAR2;

SELECT kupv$ft.error_text(20099, 'Test Msg', 'XML', 'Z')

      FROM dual;

      

      KUPV$FT.ERROR_TEXT(20099,'TESTMSG','XML','Z')

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

      ORA-20099: Test Msg

FLUSH_TIMINGS

Flush DataPump timings kupv$ft.flush_timings;

exec kupv$ft.flush_timings;

      

      PL/SQL procedure successfully completed.

GET_FORMATTED_TIME

Time string formatter kupv$ft.get_formatted_time RETURN VARCHAR2;

SELECT kupv$ft.get_formatted_time

      FROM dual;

      

      GET_FORMATTED_TIME

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

      18:38:31.229

HAS_PRIVS

Undocumented kupv$ft.has_privs( operation IN VARCHAR2, caller_type IN BINARY_INTEGER, linkname IN VARCHAR2) RETURN NUMBER;

TBD

MATCH_MT_VERSION

Undocumented kupv$ft.match_mt_version( job_version IN NUMBER, new_version OUT VARCHAR2, obj_schema OUT VARCHAR2, obj_name OUT VARCHAR2) RETURN BOOLEAN;

TBD

MESSAGE_TEXT

Undocumented kupv$ft.message_text( message_num IN NUMBER, parameter1 IN VARCHAR2, parameter2 IN VARCHAR2, parameter3 IN VARCHAR2, parameter4 IN VARCHAR2, parameter5 IN VARCHAR2, parameter6 IN VARCHAR2, parameter7 IN VARCHAR2, parameter8 IN VARCHAR2) RETURN VARCHAR2;

SELECT kupv$ft.message_text(20099, 'Test Msg', 'A', 'B', 'C', 'D', 'E', 'F', 'G')

      FROM dual;

      

      KUPV$FT.MESSAGE_TEXT(20099,'TESTMSG','A','B','C','D','E','F','G')

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

      Test Msg

OPEN_JOB

Undocumented kupv$ft.open_job( user_name IN VARCHAR2, job_name IN VARCHAR2, operation IN VARCHAR2, job_mode IN VARCHAR2, ena_sec_roles IN NUMBER) RETURN NUMBER;

TBD

RECORD_DELTA_TIMINGS

Undocumented kupv$ft.record_delta_timings( t_handle IN OUT NUMBER, comp_id IN VARCHAR2, intro_text IN VARCHAR2);

TBD

SET_APPLICATION_ROLE

Undocumented kupv$ft.set_application_role;

exec kupv$ft.set_application_role;

      

      PL/SQL procedure successfully completed.

SET_LONGOPS

Writes longops data to v$session_longoops.

This API can be leveraged by application developers to provide incredible value kupv$ft.set_longops( context_1 IN OUT BINARY_INTEGER, context_2 IN OUT BINARY_INTEGER, job_name IN VARCHAR2, operation IN VARCHAR2, work_sofar IN NUMBER, work_total IN NUMBER, completed IN BOOLEAN, percentages IN BOOLEAN);

DECLARE

       ctx0 BINARY_INTEGER := 0;

       ctx1 BINARY_INTEGER := 1;

      BEGIN

        kupv$ft.set_longops(ctx0, ctx1, 'UW Job', 'OpName', 50, 100, FALSE, TRUE);

        dbms_output.put_line(ctx0);

        dbms_output.put_line(ctx1);

      END;

      /

      377

      3864

      

      PL/SQL procedure successfully completed.

      

      SELECT sid, serial#, opname,sofar, totalwork, start_time, last_update_time, context

      FROM v$session_longops

      WHERE opname LIKE 'UW%';

      

       SID SERIAL# OPNAME SOFAR TOTALWORK START_TIME           LAST_UPDATE_TIME    CONTEXT

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

       154   10391 UW Job    50       100 05-OCT-2021 19:24:56 05-OCT-2021 19:24:56      0

START_TIMINGS

Undocumented kupv$ft.start_timings( t_handle IN OUT NUMBER, comp_id IN VARCHAR2, intro_text IN VARCHAR2);

TBD