Oracle | PSTDY_DATAPUMP

Oracle PSTDY_DATAPUMP_SUPPORT 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 but appears to relate to Data Guard Physical Standby DataPump Support

AUTHID DEFINER

Dependencies

DBMS_DATAPUMP

KU$_JOBDESC

KU$_STATUS

Documented No

First Available 12.1

Security Model Owned by SYS with EXECUTE granted to EXECUTE_CATALOG_ROLE role

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

Subprograms

INSTANCE_CALLOUT_IMP

INSTANCE_EXPORT_ACTION

INSTANCE_CALLOUT_IMP

Undocumented

Demo fails because it was not run from within an executing DataPump job.

Identical name and parameters were found in TSDP$DATAPUMP pstdy_datapump_support.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);

CREATE TABLE c##uwclass.test AS

      SELECT * FROM tab$;

      

      Table created.

      

      SELECT type#

      FROM obj$

      WHERE name = 'TEST';

      

       TYPE#

      ------

           2

      

      DECLARE

       lAction  VARCHAR2(120);

       lAltName VARCHAR2(120);

      BEGIN

        pstdy_datapump_support.instance_callout_imp('TEST', 'C##UWCLASS', 2, 0, lAction, lAltName);

        dbms_output.put_line(lAction);

        dbms_output.put_line(lAltName);

      END;

      /

      DECLARE

      *

      ERROR at line 1:

      ORA-31623: a job is not attached to this session via the specified handle

      ORA-06512: at "SYS.DBMS_DATAPUMP", line 4747

      ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79

      ORA-06512: at "SYS.DBMS_DATAPUMP", line 4494

      ORA-06512: at "SYS.DBMS_DATAPUMP", line 5973

      ORA-06512: at "SYS.PSTDY_DATAPUMP_SUPPORT", line 42

      ORA-06512: at line 5

INSTANCE_EXPORT_ACTION

Undocumented

Demo code doesn't fail but neither is there an output pstdy_datapump_support.instance_export_action( obj_name IN VARCHAR2, obj_schema IN VARCHAR2, obj_type IN NUMBER, tgt_version IN VARCHAR2, action OUT VARCHAR2, alt_name OUT VARCHAR2, where_clause OUT VARCHAR2);

DECLARE

       lAction  VARCHAR2(128);

       lAltName VARCHAR2(128);

       lWhereCl VARCHAR2(128);

      BEGIN

        pstdy_datapump_support.instance_export_action('TEST', 'C##UWCLASS', 2, '21.1.0', lAction, lAltName, lWhereCl);

        dbms_output.put_line(lAction);

        dbms_output.put_line(lAltName);

        dbms_output.put_line(lWhereCl);

      END;

      /

      

      PL/SQL procedure successfully completed.