Oracle | LT_EXPORT

Oracle LT_EXPORT_PKG Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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	GET_INTERNAL_OBJECTS	RECOMPUTEALLVTROWIDS
EXPORT_MAPPING_VIEW_FUNC	IMPORT_SCHEMAS	SCHEMA_INFO_EXP
EXPORT_METADATA_VIEW_FUNC	INITIALIZE	SYSTEM_CALLOUT
EXPORT_SCHEMAS	INSTANCE_CALLOUT_IMP	SYSTEM_CALLOUT_IMP
GET_DATAPUMP_ID	INSTANCE_EXPORT_ACTION	SYSTEM_INFO_EXP

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