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
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_INT
DBMS_DATAPUMP_UTL
Export
Import
Packages
TSDP$DATAPUMP
What's New In 12cR1
What's New In 12cR2

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-2017 Daniel A. Morgan All Rights Reserved