Oracle | AMGT$DATAPUMP

Oracle AMGT$DATAPUMP 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 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;

      /