Oracle | PSTDY_DATAPUMP

Oracle PSTDY_DATAPUMP_SUPPORT Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Internal DataPump support package for Data Guard Physical Standbys

AUTHID DEFINER

Dependencies

DBMS_DATAPUMP

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;

      /

      *

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

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.