Oracle PSTDY_DATAPUMP_SUPPORT
Version 18.3

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose Undocumented but appears to relate to Data Guard Physical Standby DataPump Support
AUTHID DEFINER
Dependencies
DBMS_DATAPUMP KU$_JOBDESC KU$_STATUS
Documented No
First Available 12.1
Security Model Owned by SYS with EXECUTE granted to EXECUTE_CATALOG_ROLE role
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, '18.3.0', lAction, lAltName, lWhereCl);
  dbms_output.put_line(lAction);
  dbms_output.put_line(lAltName);
  dbms_output.put_line(lWhereCl);
END;
/

Related Topics
AMGT$DATAPUMP
Built-in Functions
Built-in Packages
DataPump Executable
DBMS_DATAPUMP_INT
DBMS_DATAPUMP_UTL
Export
Import
OLS$DATAPUMP
Packages
TSDP$DATAPUMP
What's New In 18c
What's New In 19c

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