Search Results dbms_offline_rgt




Overview
Explore in AI Chat

Overview

SYS.DBMS_OFFLINE_RGT is an Oracle-supplied PL/SQL package that forms part of the core replication infrastructure shipped with the Oracle Database, rather than a component authored specifically for Oracle E-Business Suite. Within the ETRM metadata the object is classified under owner SYS with an API classification of OTHER, reflecting its role as a database-level utility rather than an EBS application API. Its name follows the Oracle replication naming convention, where the OFFLINE prefix denotes tools supporting deferred or disconnected-site instantiation, and RGT refers to the replicated object group technology that underpins Oracle's symmetric replication model. In an EBS 12.1.1 or 12.2.2 environment, the package exists primarily as a dependency artifact surfaced during analysis of the EBS schema, since EBS deployments rely on a single database instance and do not ordinarily enable multi-master replication. The package is therefore relevant chiefly to administrators auditing dependencies, assessing upgrade impact, or investigating legacy Advanced Replication configurations that may persist in older or customized environments.

Key Procedures and Functions

The ETRM documentation records zero documented procedures or functions for this package, and no parameter signatures are available. This absence is consistent with the package being a database-internal utility whose callable units are invoked implicitly by other replication components rather than by application code. The documented dependency graph shows that DBMS_OFFLINE_RGT references SYS.DBMS_REPCAT_UTL and the STANDARD package, and that it is referenced by an identically named public synonym owned by PUBLIC. No parameter lists are inventoried here, and none should be assumed.

Tables Accessed

No tables are documented as being accessed by DBMS_OFFLINE_RGT through APPS synonyms, and no base replication tables are listed in the supplied metadata. In practice, packages of this family operate against the internal SYS-owned replication catalog — the DBA_REPCAT*, DBA_REPCATLOG, and DBA_REPOBJECT views and their underlying tables — to manage object group definitions during offline instantiation. Because these objects reside in the SYS schema, they are not enumerated as EBS application tables in the ETRM registry, which explains the empty table list.

Usage Notes

DBMS_OFFLINE_RGT is not invoked from EBS forms, concurrent programs, or standard application workflows. It is typically called only in environments where Oracle Advanced Replication has been configured, for example when building or refreshing a replicated object group at a disconnected site. Administrators encountering this package in an EBS 12.1.1 or 12.2.2 database should treat it as an Oracle-owned system object: it should not be modified, and its presence should not be interpreted as evidence that replication is active. The documented reference from PUBLIC indicates that a synonym exists, granting general name resolution, but this does not imply application-level dependency. Custom code should never call this package directly.