Oracle 12cR2 PSTDY_DATAPUMP

Oracle PSTDY_DATAPUMP_SUPPORT Version 12.2.0.1

General Information

Library Note

Morgan's Library Page Header

"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"

~ Sen. Tammy Duckworth

Purpose Undocumented but appears to relate to Data Guard Physical Standby DataPump Support

AUTHID DEFINER

Dependencies

DBMS_DATAPUMP

Documented No

First Available 12.1.0

Security Model Owned by SYS with EXECUTE granted to EXECUTE_CATALOG_ROLE and SELECT_CATALOG_ROLE roles.

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

Subprograms

INSTANCE_CALLOUT_IMP

INSTANCE_EXPORT_ACTION

INSTANCE_CALLOUT_IMP

Undocumented

Demo code doesn't fail but neither is there an output

But identical name and parameters 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##abc.test AS

      SELECT * FROM tab$;

      

      SELECT type#

      FROM obj$

      WHERE name = 'TEST';

      

      DECLARE

       lAction  VARCHAR2(120);

       lAltName VARCHAR2(120);

      BEGIN

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

        dbms_output.put_line(lAction);

        dbms_output.put_line(lAltName);

      END;

      /

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##ABC', 2, '12.1.0', lAction, lAltName, lWhereCl);

        dbms_output.put_line(lAction);

        dbms_output.put_line(lAltName);

        dbms_output.put_line(lWhereCl);

      END;

      /