Oracle LT_EXPORT_PKG
Version 21c

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 Workspace Management Export Utilities
AUTHID DEFINER
Dependencies
ALL_CONSTRAINTS LTUTIL WM$EXP_MAP_TAB
ALL_USERS LT_CTX_PKG WM$EXP_MAP_TYPE
DBA_CONSTRAINTS OWM_ASSERT_PKG WM$INSTEADOF_TRIGS_TABLE
DBA_DATAPUMP_JOBS OWM_DDL_PKG WM$INTERNAL_OBJECTS
DBA_IND_COLUMNS OWM_MIG_PKG WM$METADATA_MAP
DBA_OBJECTS OWM_VSCRIPT_PKG WM$METADATA_MAP_TAB
DBA_TABLES PLITBLM WM$METADATA_MAP_TYPE
DBMS_DATAPUMP REGISTRY$ WM$NESTED_COLUMNS_TABLE$
DBMS_LOCK UD_TRIGS WM$RIC_TABLE
DBMS_REGISTRY V$DATAPUMP_JOB WM$RIC_TRIGGERS_TABLE
DUAL V$DATAPUMP_SESSION WM$UDTRIG_DISPATCH_PROCS
IMPCALLOUTREG$ V$SESSION WM$UDTRIG_INFO
KU$_JOBDESC1220 WM$CONSTRAINTS_TABLE WM$VERSIONED_TABLES
KU$_JOBSTATUS1220 WM$CONSTRAINTS_TABLE$ WM$VERSIONED_TABLES$
KU$_STATUS WM$ED_UNDO_CODE_NODE_TYPE WM$VERSIONED_TABLES$H
KUPW$WORKER WM$ED_UNDO_CODE_TABLE_TYPE WM$VERSION_HIERARCHY_TABLE$
LT WM$ENV_VARS$ WM_ERROR
LTADM WM$EXP_MAP WM_INSTALLATION
Documented No
First Available Not known
Security Model Owned by WMSYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/owmexps.plb
{ORACLE_HOME}/rdbms/admin/owmexpb.plb
Subprograms
 
EXPORTWMSYS
Undocumented lt_export_pkg.exportWMSYS(
alt_schema IN VARCHAR2,
dumpdir    IN VARCHAR2,
dumpfile   IN VARCHAR2);
TBD
 
EXPORT_MAPPING_VIEW_FUNC
Undocumented lt_export_pkg.export_mapping_view_func RETURN wmsys.wm$exp_map_tab PIPELINED;
col vfield1 format a10
col vfield2 format a15
col vfield3 format a10

SELECT * FROM TABLE(wmsys.lt_export_pkg.export_mapping_view_func);

 CODE   NFIELD1  NFIELD2  NFIELD3 VFIELD1    VFIELD2         VFIELD3
------ -------- -------- -------- ---------- --------------- --------
     0        0        2           WMSYS     WM$LOG_TABLE
     0       -1        2           WMSYS     WM$RENAME_COL
     0       -2        2           WMSYS     WM$IMP_EXP
 
EXPORT_METADATA_VIEW_FUNC
Undocumented lt_export_pkg.export_metadata_view_func RETURN wmsys.wm$metadata_map_tab PIPELINED;
SELECT * FROM TABLE(wmsys.lt_export_pkg.export_metadata_view_func);

no rows selected
 
EXPORT_SCHEMAS
Undocumented lt_export_pkg.export_schemas(
jobowner_v        IN VARCHAR2,
jobname_v         IN VARCHAR2,
alt_schema_v      IN VARCHAR2,
ignore_last_error IN BOOLEAN,
wmsys_only        IN BOOLEAN);
TBD
 
GET_DATAPUMP_ID
Undocumented lt_export_pkg.get_datapump_id(
jobowner    IN VARCHAR2,
jobname     IN VARCHAR2,
job_type    IN VARCHAR2,
return_null IN BOOLEAN)
RETURN NUMBER;
TBD
 
GET_INTERNAL_OBJECTS
Undocumented lt_export_pkg.get_internal_objects RETURN wmsys.wm$exp_map_tab PIPELINED;
SELECT * FROM TABLE(wmsys.lt_export_pkg.get_internal_objects);

no rows selected
 
IMPORT_SCHEMAS
Undocumented lt_export_pkg.import_schemas(
jobowner_v        IN VARCHAR2,
jobname_v         IN VARCHAR2,
alt_schema_v      IN VARCHAR2,
ignore_last_error IN BOOLEAN,
wmsys_only        IN BOOLEAN);
TBD
 
INITIALIZE
Undocumented lt_export_pkg.initialize(
alt_schema   IN VARCHAR2,
updatetable  IN BOOLEAN,
wmsys_only_v IN BOOLEAN);
TBD
 
INSTANCE_CALLOUT_IMP
Undocumented lt_export_pkg.instance_callout_imp(
obj_name   IN  VARCHAR2,
obj_schema IN  VARCHAR2,
obj_type   IN  NUMBER,
prepost    IN  NUMBER,
action     OUT VARCHAR2,
alt_name   OUT VARCHAR2);
TBD
 
INSTANCE_EXPORT_ACTION
Undocumented lt_export_pkg.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);
TBD
 
RECOMPUTEALLVTROWIDS
Undocumented lt_export_pkg.recomputeAllVTRowids(vtid IN NUMBER);
TBD
 
SCHEMA_INFO_EXP
Undocumented lt_export_pkg.schema_info_exp(
schema    IN  VARCHAR2,
prepost   IN  NUMBER,
isdba     IN  NUMBER,
version   IN  VARCHAR2,
new_block OUT NUMBER)
RETURN VARCHAR2;
TBD
 
SYSTEM_CALLOUT
Undocumented lt_export_pkg.system_callout(
prepost IN NUMBER,
version IN VARCHAR2);
TBD
 
SYSTEM_CALLOUT_IMP
Undocumented lt_export_pkg.system_callout_imp(prepost IN NUMBER);
TBD
 
SYSTEM_INFO_EXP
Undocumented lt_export_pkg.system_info_exp(
prepost       IN  NUMBER,
connectstring OUT VARCHAR2,
version       IN  VARCHAR2,
new_block     OUT NUMBER)
RETURN VARCHAR2;
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
What's New In 19c
What's New In 20c-21c

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