Search Results instantiate_offline




Overview
Explore in AI Chat

Overview

SYS.DBMS_REPCAT_INSTANTIATE is an Oracle-supplied PL/SQL package that belongs to the Oracle Advanced Replication infrastructure and is present in the SYS schema of every Oracle E-Business Suite database, including releases 12.1.1 and 12.2.2. Its business function is to perform the instantiation phase of multi-master and materialized-view replication configurations — that is, the creation and removal of the database objects required at a replicated site so that it can participate in a replicated object group. Instantiation covers the generation of internal triggers, shadow tables, and change-capture infrastructure on the target site, together with the registration of the site in the replication catalog.

In EBS environments, this package is most frequently encountered when cloning, refreshing, or re-pointing a database that participates in an Advanced Replication topology, and when diagnosing errors that surface during DBMS_REPCAT or DBMS_REPCAT_ADMIN operations. The package status recorded in ETRM is VALID and its owner is SYS.

Key Procedures and Functions

The ETRM metadata documents four entry points. Parameter lists are intentionally not reproduced here; only documented purposes are described.

  • INSTANTIATE_ONLINE — Performs online instantiation of a replicated object group at a target site. The operation executes while the master site is available and normally relies on internal replication mechanisms to synchronize the target site.
  • INSTANTIATE_OFFLINE — Performs offline instantiation, in which the replicated objects are created at the target site without a live connection to the master definition site. This is the variant used when a site must be built from an exported copy of the master data.
  • INSTANTIATE_OFFLINE_REPAPI — The replication API-level counterpart to the offline instantiation routine. It supports the same offline build process but is intended for invocation through the replication API surface rather than the direct package entry point.
  • DROP_SITE_INSTANTIATION — Removes the instantiation artifacts previously created for a site, effectively de-registering the site's instantiated object group and cleaning up the supporting objects.

All four routines are administrative in nature and should be executed only by a replication administrator operating with the privileges appropriate to replication management.

Tables Accessed

The ETRM extract for this object lists no tables referenced through APPS synonyms, and the dependency section of the source documentation records only internal references to SYS.STANDARD. In practice, the package operates against the replication catalog tables owned by SYS — notably the DBA_REPCAT, DBA_REPOBJECT, and related data dictionary views and base tables that record object groups, sites, and instantiation state. Because these are SYS-owned catalog objects rather than application tables, no APPS synonym layer is involved.

Usage Notes

DBMS_REPCAT_INSTANTIATE is not called from standard EBS forms or concurrent programs. It is invoked through SQL*Plus or a DBA session, typically as part of a documented Advanced Replication setup or teardown procedure. In EBS 12.1.1 and 12.2.2, the most common practical scenario is a rapid clone or an environment refresh where replication metadata must be reset, or a troubleshooting exercise following errors such as ORA-23313 during a DBMS_REPCAT operation. The package is referenced by PUBLIC and by SYS only, and it is not a dependency of any other package in the ETRM catalog. Oracle recommends using the higher-level DBMS_REPCAT wrappers where possible, reserving direct calls to this package for administrative recovery and offline site construction.