Oracle PSTDY_DATAPUMP_SUPPORT
Version 12.1.0.1

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

Related Topics
AMGT$DATAPUMP
DataPump Executable
DBMS_DATAPUMP_UTL
Export
Import
Packages
TSDP$DATAPUMP

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2014 Daniel A. Morgan All Rights Reserved