Oracle 12cR2 PSTDY_DATAPUMP

Oracle PSTDY_DATAPUMP_SUPPORT Version 12.2.0.1

General Information

Library Note

Morgan's Library Page Header

Coming to OpenWorld 2018? Be sure to visit the TidalScale booth in Moscone South and learn how to solve performance problems and lower costs with Software Defined Servers. Before you visit the booth, or if you can't make it this year, check out TidalScale at www.tidalscale.com. Be sure to click on the Solutions link and look through the Oracle resources.

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;

      /