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 will be available on generic Linux platforms in January and soon on AIX and Windows

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