Oracle | DBMS_DATAPUMP

Oracle DBMS_DATAPUMP_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 Undocumented support for DataPump.

This package was dropped in 12.1.0 and reinstantiated in 12.2.0.

AUTHID DEFINER

Dependencies

DBMS_ASSERT	KU$_DUMPFILESET	KUPCC
DBMS_DATAPUMP	KU$_JOBDESC	KUPF$FILE
DBMS_LOCK	KU$_JOBSTATUS	KUPP$PROC
DBMS_OUTPUT	KU$_PARAMVALUE	KUPUTIL
DBMS_SYS_ERROR	KU$_PARAMVALUES	KUPV$FT_INT
DBMS_UTILITY	KU$_WORKERSTATUS	PLITBLM
KU$_DUMPFILE	KU$_WORKERSTATUSLIST

Documented No

First Available 12.2 (see note above)

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

Source {ORACLE_HOME}/rdbms/admin/prvthdpi.plb

Subprograms

GET_DUMPFILESET	GET_OBJECT_INFO	GET_WORKERSTATUSLIST
GET_JOBDESC	GET_PARAMVALUES	SET_DEBUG
GET_JOBSTATUS

GET_DUMPFILESET

Returns information about a DataPump file set dbms_datapump_int.get_dumpfileset( handle IN NUMBER, job_rec IN kupcc.dpapi_job_record) RETURN SYS.KU$_DUMPFILESET;

TBD

GET_JOBDESC

Returns the description of a DataPump job dbms_datapump_int.get_jobdesc( handle IN NUMBER, job_rec IN kupcc.dpapi_job_record) RETURN sys.ku$_jobdesc;

TBD

GET_JOBSTATUS

Returns the status of a DataPump job dbms_datapump_int.get_jobstatus( handle IN NUMBER, job_rec IN kupcc.dpapi_job_record) RETURN sys.ku$_jobstatus;

TBD

GET_OBJECT_INFO

Returns information at the object level from a DataPump job dbms_datapump_int.get_object_info( job_rec IN kupcc.dpapi_job_record, object_owner IN VARCHAR2, object_name IN VARCHAR2, object_type IN VARCHAR2, processing_status OUT VARCHAR2, processing_state OUT VARCHAR2);

TBD

GET_PARAMVALUES

Returns information about DataPump parameter values dbms_datapump_int.get_paramvalues( handle IN NUMBER, job_rec IN kupcc.dpapi_job_record) RETURN sys.ku$_paramvalues;

TBD

GET_WORKERSTATUSLIST

Returns an array of DataPump workers and their status dbms_datapump_int.get_workerstatuslist( handle IN NUMBER, job_rec IN kupcc.dpapi_job_record) RETURN sys.ku$_workerstatuslist;

TBD

SET_DEBUG

Enables/disables debugging dbms_datapump_int.set_debug(on_off IN BOOLEAN);

exec dbms_datapump_int.set_debug(TRUE);