Oracle | PSTDY_DATAPUMP

Oracle PSTDY_DATAPUMP_SUPPORT 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 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.