Oracle DBMS_DATAPUMP

Oracle DBMS_DATAPUMP_INT 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 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);