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

Related Topics
Built-in Functions
Built-in Packages
Database Security
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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx