Oracle | LT_EXPORT

Oracle LT_EXPORT_PKG Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Workspace Management Export Utilities

AUTHID CURRENT_USER

Dependencies

ALL_CONSTRAINTS	LTDEFINER	WM$ED_UNDO_CODE_TABLE_TYPE
ALL_IND_COLUMNS	LTUTIL	WM$ENV_VARS$
ALL_USERS	LT_CTX_PKG	WM$EXP_MAP
DBA_CONSTRAINTS	LT_EXPORT_PKG	WM$EXP_MAP_TAB
DBA_DATAPUMP_JOBS	OWM_ASSERT_PKG	WM$EXP_MAP_TYPE
DBA_OBJECTS	OWM_DDL_PKG	WM$INSTEADOF_TRIGS_TABLE
DBA_REGISTRY	OWM_MIG_PKG	WM$INTERNAL_OBJECTS
DBA_TABLES	OWM_VSCRIPT_PKG	WM$METADATA_MAP
DBMS_DATAPUMP	PLITBLM	WM$METADATA_MAP_TAB
DBMS_LOCK	UD_TRIGS	WM$METADATA_MAP_TYPE
DBMS_REGISTRY	VERSIONED_TABLES_NT	WM$NESTED_COLUMNS_TABLE$
DUAL	VERSIONED_TABLES_REC	WM$RIC_TABLE
IMPCALLOUTREG$	VERSION_HIERARCHY_TABLE	WM$RIC_TRIGGERS_TABLE
KU$_JOBDESC1220	V_$DATAPUMP_JOB	WM$UDTRIG_DISPATCH_PROCS
KU$_JOBSTATUS1220	V_$DATAPUMP_SESSION	WM$UDTRIG_INFO
KU$_STATUS	V_$SESSION	WM$VERSIONED_TABLES
KUPW$WORKER	WM$CONSTRAINTS_TABLE	WM$VERSIONED_TABLES$
LT	WM$CONSTRAINTS_TABLE$	WM$VERSIONED_TABLES$H
LTADM	WM$ED_UNDO_CODE_NODE_TYPE	WM_ERROR

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