Search Results dbms_streams_datapump_util




Overview
Explore in AI Chat

Overview

SYS.DBMS_STREAMS_DATAPUMP_UTIL is an internal Oracle-supplied PL/SQL package body classified as a utility (UTIL) API within the E-Business Suite technology stack. It functions as the Data Pump interoperability layer for Oracle Streams, providing the procedural glue that allows Streams capture, propagation, and apply components to be exported and imported through Data Pump job infrastructure. In the Oracle EBS 12.1.1 and 12.2.2 architectures, this package is part of the core SYS schema and is installed with the database, not with the EBS product schemas. Its presence in the ETRM inventory confirms it is a validated, dependency-tracked object whose integrity is monitored as part of the EBS technology stack reference model.

The package does not implement business logic. Rather, it exposes the internal plumbing required to move Streams metadata — rule sets, capture processes, apply processes, and queue definitions — using exponent Data Pump export and import operations. Because EBS relies on Streams in advanced replication, data guard, and information-sharing configurations, this utility indirectly supports the movement of transactional data between EBS instances.

Key Procedures and Functions

The ETRM metadata for this object documents zero public procedures or functions. This is consistent with a package body whose members are intended for internal consumption by other SYS packages rather than by application code. The package body supplies the implementation underlying the Data Pump-oriented Streams APIs, including the routines that construct Data Pump job descriptions, parameter lists, and status structures used when Streams components are exported or imported.

  • No documented standalone procedures or functions are exposed for customer invocation.
  • Implementation routines are consumed exclusively by sibling SYS packages such as DBMS_STREAMS_MT and DBMS_DATAPUMP.
  • All entry points are internal; no supported public API signature is published in the ETRM record.

Tables Accessed

The dependency list identifies the following Data Pump dictionary objects, which the package body references during job construction and status reporting:

  • KU$_JOBDESC — the Data Pump job description structure, used to define the parameters of a Streams export or import operation.
  • KU$_PARAMVALUE and KU$_PARAMVALUES — typed parameter collections used to pass and retrieve Data Pump job options.
  • KU$_STATUS — the job status record used to report progress and completion state.

These are fixed-object metadata tables belonging to the Data Pump dictionary API, not application tables. The package also depends on PUBLIC.KU$_PARAMVALUE1010, DBMS_DATAPUMP, DBMS_STREAMS_MT, PLITBLM, and STANDARD, and on the internal view _DBA_APPLY_SOURCE_SCHEMA.

Usage Notes

DBMS_STREAMS_DATAPUMP_UTIL is never invoked directly from EBS Forms, concurrent programs, or customer PL/SQL. It is called internally when a Streams component is exported or imported using Data Pump, for example during stream migration, clone preparation, or replication reconfiguration on 12.1.1 and 12.2.2 environments. The ETRM record shows the object is referenced by nine other database objects, confirming its role as a shared internal dependency rather than a user-facing API. DBAs diagnosing Streams or Data Pump errors may encounter this package in dependency trees, but no modification or direct call should be attempted; all interaction occurs through the supported DBMS_STREAMS and DBMS_DATAPUMP packages.