Search Results dbms_logrep_util

Overview

SYS.DBMS_LOGREP_UTIL is an Oracle-supplied PL/SQL package body that forms part of the internal LogMiner and Oracle Streams replication infrastructure. Within the Oracle E-Business Suite 12.1.1 and 12.2.2 technology stack, this package provides the utility layer used to administer, validate, and manage the log-based capture and apply mechanisms that underpin advanced replication, Streams, and GoldenGate integration. The package is owned by SYS, holds a VALID status, and is classified as a UTIL object, indicating that it exposes helper routines rather than a public business-facing API.

The object is not referenced by any database object directly, yet it is itself a heavy consumer of other Oracle replication packages and dictionary views. This asymmetrical dependency profile confirms its role as an internal support module invoked indirectly through higher-level APIs such as DBMS_CAPTURE_ADM, DBMS_APPLY_ADM, and DBMS_STREAMS_ADM.

Key Procedures and Functions

The ETRM metadata for version 12.2.2 documents the package with a zero procedure/function count, meaning no public callable units are registered as documented entry points. All logic is therefore treated as private implementation detail. Based on the dependency information, the package body serves the following functional purposes:

Validation and assertion of schema, object, and privilege names through its dependency on DBMS_ASSERT, ensuring that caller-supplied identifiers are safe before dynamic SQL is constructed.
Administration of capture and apply processes, evidenced by references to DBA_CAPTURE, DBA_APPLY, ALL_CAPTURE, ALL_APPLY, STREAMS$_CAPTURE_PROCESS, and STREAMS$_APPLY_PROCESS.
Queue and rules management, indicated by references to DBA_QUEUES, DBMS_AQADM_SYS, DBA_RULES, DBA_RULE_SETS, and DBMS_RULE_ADM.
GoldenGate and XStream privilege and stream administration, reflected by DBA_GOLDENGATE_PRIVILEGES, DBMS_XSTREAM_ADM, DBMS_XSTREAM_GG, DBMS_XSTREAM_GG_ADM, and the _DBA_GGXSTREAM_INBOUND / _DBA_GGXSTREAM_OUTBOUND views.
Privilege verification against DBA_ROLES, DBA_ROLE_PRIVS, DBA_STREAMS_ADMINISTRATOR, DBA_XSTREAM_ADMINISTRATOR, and SYSTEM_PRIVILEGE_MAP.
Container and multitenant awareness via CDB_PDBS and CDB_PROPERTIES, supporting pluggable database deployments common in 12.2.2 environments.

Tables Accessed

The package reads from and manipulates several dictionary and fixed views. The DBA_/ALL_ capture and apply views supply configuration and status data for replication processes. The STREAMS$_ fixed tables provide runtime state for capture, apply, propagation, and message consumer processes. DBA_QUEUES and the AQ$_QUEUES/AQ$_QUEUE_TABLES views support Oracle Advanced Queuing used to transport logical change records. Replication metadata resides in REPL$_DBNAME_MAPPING and RE$NV_LIST, while GLOBAL_NAME and LOGMNR_RESTART_CKPT$ support LogMiner restart checkpointing. Role and privilege tables are consulted for authorization checks.

Usage Notes

DBMS_LOGREP_UTIL is never invoked directly from EBS forms, concurrent programs, or standard application code. It is called internally by Oracle's replication and Streams administration packages, including DBMS_CAPTURE_ADM, DBMS_APPLY_ADM, DBMS_STREAMS_ADM_UTL, DBMS_STREAMS_ADV_ADM_UTL, and DBMS_LOGREP_LIB. Administrators interact with it only indirectly when configuring downstream capture, Streams replication, or GoldenGate integration against EBS 12.1.1 or 12.2.2 databases. Because the package is SYS-owned and executes with definer's rights, direct execution by application schemas is neither supported nor recommended. Any custom code that attempts to call it should be considered unsupported and may fail after patching or upgrades, since Oracle reserves the right to modify internal signatures without notice.

TYPE: SYS.RE$NV_LIST 12.1.1
owner:SYS, object_type:TYPE, object_name:RE$NV_LIST, status:VALID,
PACKAGE BODY: SYS.DBMS_LOGREP_UTIL 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_LOGREP_UTIL, status:VALID,
VIEW: SYS._DBA_GGXSTREAM_OUTBOUND 12.1.1
owner:SYS, object_type:VIEW, object_name:_DBA_GGXSTREAM_OUTBOUND, status:VALID,
VIEW: SYS._DBA_GGXSTREAM_OUTBOUND 12.2.2
owner:SYS, object_type:VIEW, object_name:_DBA_GGXSTREAM_OUTBOUND, status:VALID,
TYPE: SYS.RE$NV_LIST 12.2.2
owner:SYS, object_type:TYPE, object_name:RE$NV_LIST, status:VALID,
PACKAGE BODY: SYS.DBMS_LOGREP_UTIL 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_LOGREP_UTIL, status:VALID,
PACKAGE BODY: SYS.DBMS_STREAMS_CDC_ADM 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_STREAMS_CDC_ADM, status:VALID,
PACKAGE BODY: SYS.DBMS_APPLY_POSITION 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_APPLY_POSITION, status:VALID,
PACKAGE BODY: SYS.DBMS_STREAMS_CDC_ADM 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_STREAMS_CDC_ADM, status:VALID,
PACKAGE: SYS.DBMS_LOCK 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_LOCK, status:VALID,
PACKAGE BODY: SYS.DBMS_APPLY_POSITION 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_APPLY_POSITION, status:VALID,
PACKAGE: SYS.DBMS_LOCK 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_LOCK, status:VALID,
PACKAGE BODY: SYS.DBMS_DEFERGEN_LOB 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DEFERGEN_LOB, status:VALID,
PACKAGE: SYS.DBMS_XSTREAM_GG 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_XSTREAM_GG, status:VALID,
PACKAGE BODY: SYS.DBMS_XSTREAM_GG 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_XSTREAM_GG, status:VALID,
PACKAGE: SYS.DBMS_XSTREAM_GG 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_XSTREAM_GG, status:VALID,
PACKAGE BODY: SYS.DBMS_MAINT_GEN 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_MAINT_GEN, status:VALID,
PACKAGE BODY: SYS.DBMS_GOLDENGATE_AUTH 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_GOLDENGATE_AUTH, status:VALID,
PACKAGE BODY: SYS.DBMS_STREAMS_ADM 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_STREAMS_ADM, status:VALID,
PACKAGE BODY: SYS.DBMS_XSTREAM_GG 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_XSTREAM_GG, status:VALID,
PACKAGE BODY: SYS.DBMS_DEFERGEN_LOB 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DEFERGEN_LOB, status:VALID,
PACKAGE: SYS.DBMS_STREAMS_ADV_ADM_UTL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_STREAMS_ADV_ADM_UTL, status:VALID,
PACKAGE BODY: SYS.DBMS_STREAMS_ADM 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_STREAMS_ADM, status:VALID,
PACKAGE BODY: SYS.DBMS_STREAMS_ADVISOR_ADM 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_STREAMS_ADVISOR_ADM, status:VALID,
PACKAGE: SYS.DBMS_CMP_INT 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_CMP_INT, status:VALID,
PACKAGE BODY: SYS.DBMS_LOGREP_IMP_INTERNAL 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_LOGREP_IMP_INTERNAL, status:VALID,
PACKAGE BODY: SYS.DBMS_STREAMS_MESSAGING 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_STREAMS_MESSAGING, status:VALID,
PACKAGE BODY: SYS.DBMS_APPLY_HANDLER_ADM 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_APPLY_HANDLER_ADM, status:VALID,
PACKAGE BODY: SYS.DBMS_STREAMS_PUB_RPC 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_STREAMS_PUB_RPC, status:VALID,
PACKAGE BODY: SYS.DBMS_MAINT_GEN 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_MAINT_GEN, status:VALID,
PACKAGE BODY: SYS.DBMS_STREAMS_PUB_RPC 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_STREAMS_PUB_RPC, status:VALID,
PACKAGE BODY: SYS.DBMS_LOGREP_UTIL_INVOK 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_LOGREP_UTIL_INVOK, status:VALID,
PACKAGE: SYS.DBMS_STREAMS_ADV_ADM_UTL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_STREAMS_ADV_ADM_UTL, status:VALID,
PACKAGE BODY: SYS.DBMS_STREAMS_ADVISOR_ADM 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_STREAMS_ADVISOR_ADM, status:VALID,
PACKAGE BODY: SYS.DBMS_STREAMS_HANDLER_ADM 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_STREAMS_HANDLER_ADM, status:VALID,
PACKAGE BODY: SYS.DBMS_STREAMS_HANDLER_ADM 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_STREAMS_HANDLER_ADM, status:VALID,
PACKAGE BODY: SYS.DBMS_LOGREP_UTIL_INVOK 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_LOGREP_UTIL_INVOK, status:VALID,
PACKAGE BODY: SYS.DBMS_CAPTURE_PROCESS 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_CAPTURE_PROCESS, status:VALID,
PACKAGE BODY: SYS.DBMS_CAPTURE_PROCESS 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_CAPTURE_PROCESS, status:VALID,
PACKAGE BODY: SYS.DBMS_APPLY_HANDLER_ADM 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_APPLY_HANDLER_ADM, status:VALID,
PACKAGE BODY: SYS.DBMS_XSTREAM_AUTH 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_XSTREAM_AUTH, status:VALID,
PACKAGE BODY: SYS.DBMS_GOLDENGATE_AUTH 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_GOLDENGATE_AUTH, status:VALID,
PACKAGE BODY: SYS.DBMS_XSTREAM_AUTH 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_XSTREAM_AUTH, status:VALID,
PACKAGE BODY: SYS.DBMS_RECOVERABLE_SCRIPT 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_RECOVERABLE_SCRIPT, status:VALID,
PACKAGE BODY: SYS.DBMS_STREAMS 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_STREAMS, status:VALID,
PACKAGE BODY: SYS.DBMS_STREAMS_HANDLER_INTERNAL 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_STREAMS_HANDLER_INTERNAL, status:VALID,
PACKAGE BODY: SYS.DBMS_CAPTURE_SWITCH_ADM 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_CAPTURE_SWITCH_ADM, status:VALID,
PACKAGE BODY: SYS.DBMS_DEFERGEN_AUDIT 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_DEFERGEN_AUDIT, status:VALID,
PACKAGE BODY: SYS.DBMS_APPLY_ADM_IVK 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_APPLY_ADM_IVK, status:VALID,
PACKAGE: SYS.DBMS_XSTREAM_ADM 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_XSTREAM_ADM, status:VALID,