Oracle 12c PSTDY_DATAPUMP

Oracle PSTDY_DATAPUMP_SUPPORT Version 12.1.0.2

General Information

Library Note

Morgan's Library Page Footer

The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.1 to 12.1.0.2. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Interested in Oracle GoldenGate? Check out the IGGOUG,

Purpose

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

AUTHID

DEFINER

Dependencies

DBMS_DATAPUMP

Documented

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;
/