Oracle | OLS$DATAPUMP

Oracle OLS$DATAPUMP 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 Internal DataPump support package but note that the objects are related to those in AMGT$DATAPUMP, PSTDY_DATAPUMP_SUPPORT and TSDP$DATAPUMP

AUTHID DEFINER

Dependencies

ALL_TABLES	KU$_STATUS	LBAC_PRIVS
DBMS_ASSERT	KU$_STATUS1220	OLS$POL
DBMS_DATAPUMP	LBAC_CACHE	OLS_UTIL_WRAPPER
DP_ADD_RLS_POLICY	LBAC_LABEL	PLITBLM
DP_DROP_RLS_POLICY	LBAC_LABEL_LIST	PRIVS_TO_CHAR
KU$_JOBDESC1220

Documented No

First Available 10.1

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

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

Subprograms

INSTANCE_CALLOUT_IMP

SYSTEM_CALLOUT_IMP

INSTANCE_CALLOUT_IMP

Undocumented ols$datapump.instace_callout_imp( obj_name IN VARCHAR2, obj_schema IN VARCHAR2, obj_type IN NUMBER, prepost IN BINARY_INTEGER, action OUT VARCHAR2, alt_name OUT VARCHAR2);

conn sys@pdbdev as sysdba

      

      CREATE TABLE test (

      testcol DATE);

      

      SELECT type#

      FROM obj$

      WHERE name = 'TEST';

      

      DECLARE

       actout   v$session.action%TYPE;

       anameout obj$.name%TYPE;

      BEGIN

        lbacsys.ols$datapump.instance_callout_imp('TEST', 'SYS', 2, 0, actout, anameout);

        dbms_output.put_line('Action: ' || actout);

        dbms_output.put_line('Name: ' || anameout);

      END;

      /

SYSTEM_CALLOUT_IMP

Undocumented ols$datapump.system_callout_imp(prepost IN BINARY_INTEGER);

exec lbacsys.ols$datapump.system_callout_imp(1);

      

      PL/SQL procedure successfully completed.

Morgan's Library Page Footer

This site is maintained by Dan Morgan. Last Updated:

DBSecWorx