Search Results dbms_export_extension_i




Overview
Explore in AI Chat

Overview

SYS.DBMS_EXPORT_EXTENSION_I is an internal Oracle-supplied package body that forms part of the export/import infrastructure underpinning Oracle E-Business Suite data migration, cloning, and schema extraction operations. In EBS 12.1.1 and 12.2.2, the package operates within the SYS schema and is classified under the ETRM API classification OTHER, indicating it is not a public application programming interface but rather a kernel-level utility consumed by Oracle's own export and import engine. Its stated object status is VALID, and it exposes no documented public procedures or functions to the EBS applications layer.

The _I suffix conventionally denotes an implementation or internal package body whose published specification is exposed through a sibling package. Here, the principal sibling is DBMS_EXPORT_EXTENSION, which serves as the user-visible entry point for registering and executing custom export extensions. DBMS_EXPORT_EXTENSION_I therefore carries the private logic, helper routines, and metadata manipulation required to serialize table subpartition data and LOB content during an export of partitioned objects.

Key Procedures and Functions

The ETRM metadata for this object documents no procedures or functions (0 total). EBS technical reference documentation records the package body as VALID but does not publish a callable specification, which is consistent with its classification as an internal implementation package rather than a supported API. Consultants and DBAs should not invoke DBMS_EXPORT_EXTENSION_I directly; any extension logic must be registered through the public DBMS_EXPORT_EXTENSION interface, which internally delegates work to this body. Absent a documented specification, the package is best understood as a collection of private helpers supporting the export pipeline rather than a discrete set of named entry points.

Tables Accessed

According to the documented dependency information, SYS.DBMS_EXPORT_EXTENSION_I references a defined set of data dictionary and internal metadata objects. These include COL$, COM$, EXPACT$, TABCOMPART$, and PARTLOB$, all internal SYS dictionary tables describing columns, comments, export actions, table subpartitions, and partitioned LOB segments respectively. It further references the views EXPTABSUBPARTDATA_VIEW and EXPTABSUBPARTLOB_VIEW, which surface subpartition-level data and LOB payloads for extraction.

The package also depends on several PL/SQL utility packages: DBMS_ASSERT for identifier validation, DBMS_LOB for large object manipulation, DBMS_SYSTEM, DBMS_SYS_ERROR, DBMS_STANDARD, and STANDARD for error handling and language primitives, and DBMS_EXPORT_EXTENSION itself, reflecting the two-way relationship between the public package and its implementation body. The tables are accessed to read the structural metadata required to construct export statements for partitioned tables and their LOB columns.

Usage Notes

DBMS_EXPORT_EXTENSION_I is not invoked directly from EBS forms, concurrent programs, or the Applications Dictionary. It is exercised indirectly whenever an Oracle Data Pump or legacy exp operation encounters partitioned tables with subpartition data or LOB segments, or when a registered export extension triggers the underlying machinery. Custom code integrating with the export framework should call DBMS_EXPORT_EXTENSION, never this internal body.

Because the package body is owned by SYS and is not referenced by any other database object per the documented dependency chain, it should be treated as read-only Oracle kernel code. Modifying or recompiling it is unsupported and may invalidate dependent export functionality. During EBS upgrades from 12.1.1 to 12.2.2, the package is recompiled automatically as part of the database tier patching cycle; DBAs should verify its VALID status after any upgrade or database migration to ensure export operations remain functional.