Oracle | KUPV$FT

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