Oracle AMGT$DATAPUMP

Oracle AMGT$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 script is the same one that holds DBMS_AUDIT_MGMT

AUTHID DEFINER

Dependencies

DAM_CLEANUP_EVENTS$	DBMS_AUDIT_MGMT	DBMS_STANDARD
DAM_CLEANUP_JOBS$	DBMS_AUDIT_MGMT_LIB	KU$_JOBDESC
DAM_CONFIG_PARAM$	DBMS_DATAPUMP	KU$_STATUS
DBMS_ASSERT	DBMS_PDB_EXEC_SQL

Documented No

First Available 12.1

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

Source {ORACLE_HOME}/rdbms/admin/dbmsamgt.sql

INSTANCE_CALLOUT_IMP

Undocumented amgt$datapump.instance_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

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

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

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

      END;

      /