Search Results dbms_isnapshot

Overview

SYS.DBMS_ISNAPSHOT is an Oracle-supplied internal PL/SQL package that supports the snapshot (materialized view) infrastructure within the database kernel. It is owned by the SYS schema and is reported with a status of VALID in the ETRM repository for both Oracle E-Business Suite 12.1.1 and 12.2.2. The name prefix ISNAPSHOT denotes the "internal snapshot" family of utilities that Oracle uses to manage the creation, refresh, and metadata synchronization of snapshot objects before and alongside the higher-level, publicly documented replication packages.

Within the EBS context, this package is not an Applications product API. It carries no APPS synonym, no functional module registration, and is not exposed through any concurrent program, form, or Oracle Application Object Library component. Instead, it acts as a foundational dependency of the snapshot and refresh APIs that the EBS technology stack relies upon when it queries database dictionary views, maintains DBA-managed snapshots, or coordinates refresh activity. It is correctly classified in the ETRM metadata as an OTHER API, reflecting its role as an infrastructure component rather than a business-facing interface.

Key Procedures and Functions

The ETRM metadata documents no public procedures or functions for DBMS_ISNAPSHOT. The package specification and body are present and valid, but the repository records a documented procedure/function count of zero. This is consistent with the package's internal nature: its entry points are invoked by other Oracle-provided packages rather than being called directly by user or application code.

Practically, the package provides the low-level routines that the snapshot subsystem requires — such as support logic for object identification and metadata handling — but these routines are not published or supported for direct invocation. Clients should treat DBMS_ISNAPSHOT as a dependency-only object and direct any snapshot or materialized view management activity to the supported public interfaces, principally DBMS_SNAPSHOT and its associated utilities.

Tables Accessed

The ETRM metadata does not list any base tables referenced via APPS synonyms. This is expected, because DBMS_ISNAPSHOT resides in SYS and operates on fixed dictionary objects rather than on EBS application schema tables. Any data it reads or writes pertains to snapshot metadata held in the data dictionary; no Oracle Applications tables are accessed through this package.

Usage Notes

The package is never invoked directly from EBS forms, reports, or concurrent programs. Its documented dependency graph shows that it is referenced by four packages: DBMS_ISNAPSHOT itself (internal recursion), DBMS_SNAPSHOT, DBMS_SNAPSHOT_UTL, and DBMS_SYNC_REFRESH. In turn, it depends on DBMS_UTILITY and the STANDARD package. This pattern confirms that DBMS_ISNAPSHOT sits beneath the supported snapshot and refresh APIs.

Do not call SYS.DBMS_ISNAPSHOT from custom code; Oracle does not document a public callable interface.
When diagnosing snapshot or materialized view refresh failures, treat DBMS_ISNAPSHOT as an internal node in the dependency chain, not as the entry point.
Invalidation or recompilation errors in this package should be resolved through DBMS_UTILITY recompilation and standard database maintenance, since no EBS patch or API layer exposes it.
Its validity should be confirmed with DBA_OBJECTS or ALL_OBJECTS when snapshot refresh behavior is under investigation.

PACKAGE: SYS.DBMS_ISNAPSHOT 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_ISNAPSHOT, status:VALID,
PACKAGE BODY: SYS.DBMS_ISNAPSHOT 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_ISNAPSHOT, status:VALID,
PACKAGE BODY: SYS.DBMS_ISNAPSHOT 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_ISNAPSHOT, status:VALID,
PACKAGE: SYS.DBMS_ISNAPSHOT 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_ISNAPSHOT, status:VALID,
PACKAGE: SYS.DBMS_REFRESH 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_REFRESH, status:VALID,
PACKAGE: SYS.DBMS_ISNAPSHOT 12.1.1
PACKAGE: SYS.DBMS_IREFRESH 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_IREFRESH, status:VALID,
LIBRARY: SYS.DBMS_SNAPSHOT_LIB 12.1.1
owner:SYS, object_type:LIBRARY, object_name:DBMS_SNAPSHOT_LIB, status:VALID,
LIBRARY: SYS.DBMS_SNAPSHOT_LIB 12.2.2
owner:SYS, object_type:LIBRARY, object_name:DBMS_SNAPSHOT_LIB, status:VALID,
PACKAGE: SYS.DBMS_ISNAPSHOT 12.2.2
PACKAGE: SYS.DBMS_REFRESH 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_REFRESH, status:VALID,
PACKAGE: SYS.DBMS_SNAPSHOT_UTL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_SNAPSHOT_UTL, status:VALID,
PACKAGE: SYS.DBMS_SNAPSHOT_UTL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_SNAPSHOT_UTL, status:VALID,
TABLE: SYS.SNAP_SITE$ 12.2.2
owner:SYS, object_type:TABLE, object_name:SNAP_SITE$, status:VALID,
TABLE: SYS.MLOG_REFCOL$ 12.1.1
owner:SYS, object_type:TABLE, object_name:MLOG_REFCOL$, status:VALID,
PACKAGE: SYS.DBMS_IREFRESH 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_IREFRESH, status:VALID,
TABLE: SYS.SNAP_SITE$ 12.1.1
owner:SYS, object_type:TABLE, object_name:SNAP_SITE$, status:VALID,
PACKAGE BODY: SYS.DBMS_SYNC_REFRESH 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_SYNC_REFRESH, status:VALID,
TABLE: SYS.MLOG_REFCOL$ 12.2.2
owner:SYS, object_type:TABLE, object_name:MLOG_REFCOL$, status:VALID,
TABLE: SYS.RGCHILD$ 12.2.2
owner:SYS, object_type:TABLE, object_name:RGCHILD$, status:VALID,
TABLE: SYS.REG_SNAP$ 12.2.2
owner:SYS, object_type:TABLE, object_name:REG_SNAP$, status:VALID,
PACKAGE BODY: SYS.DBMS_SYNC_REFRESH 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_SYNC_REFRESH, status:VALID,
TABLE: SYS.SNAP_REFOP$ 12.1.1
owner:SYS, object_type:TABLE, object_name:SNAP_REFOP$, status:VALID,
TABLE: SYS.RGCHILD$ 12.1.1
owner:SYS, object_type:TABLE, object_name:RGCHILD$, status:VALID,
TABLE: SYS.SNAP_REFOP$ 12.2.2
owner:SYS, object_type:TABLE, object_name:SNAP_REFOP$, status:VALID,
TABLE: SYS.SNAP_COLMAP$ 12.2.2
owner:SYS, object_type:TABLE, object_name:SNAP_COLMAP$, status:VALID,
TABLE: SYS.OLAP_TAB$ 12.1.1
owner:SYS, object_type:TABLE, object_name:OLAP_TAB$, status:VALID,
TABLE: SYS.OLAP_TAB$ 12.2.2
owner:SYS, object_type:TABLE, object_name:OLAP_TAB$, status:VALID,
PACKAGE BODY: SYS.DBMS_ISNAPSHOT 12.1.1
TABLE: SYS.REG_SNAP$ 12.1.1
owner:SYS, object_type:TABLE, object_name:REG_SNAP$, status:VALID,
TABLE: SYS.SLOG$ 12.2.2
owner:SYS, object_type:TABLE, object_name:SLOG$, status:VALID,
PACKAGE BODY: SYS.DBMS_SNAPSHOT_UTL 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_SNAPSHOT_UTL, status:VALID,
PACKAGE BODY: SYS.DBMS_SNAPSHOT_UTL 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_SNAPSHOT_UTL, status:VALID,
TABLE: SYS.SLOG$ 12.1.1
owner:SYS, object_type:TABLE, object_name:SLOG$, status:VALID,
TABLE: SYS.SNAP_COLMAP$ 12.1.1
owner:SYS, object_type:TABLE, object_name:SNAP_COLMAP$, status:VALID,
TABLE: SYS.SNAP_OBJCOL$ 12.2.2
owner:SYS, object_type:TABLE, object_name:SNAP_OBJCOL$, status:VALID,
TABLE: SYS.SNAP_REFTIME$ 12.1.1
owner:SYS, object_type:TABLE, object_name:SNAP_REFTIME$, status:VALID,
PACKAGE BODY: SYS.DBMS_SNAPSHOT 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_SNAPSHOT, status:VALID,
PACKAGE BODY: SYS.DBMS_SNAPSHOT 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_SNAPSHOT, status:VALID,
TABLE: SYS.RGROUP$ 12.1.1
owner:SYS, object_type:TABLE, object_name:RGROUP$, status:VALID,
TABLE: SYS.RGROUP$ 12.2.2
owner:SYS, object_type:TABLE, object_name:RGROUP$, status:VALID,
TABLE: SYS.SNAP_OBJCOL$ 12.1.1
owner:SYS, object_type:TABLE, object_name:SNAP_OBJCOL$, status:VALID,
TABLE: SYS.SNAP_REFTIME$ 12.2.2
owner:SYS, object_type:TABLE, object_name:SNAP_REFTIME$, status:VALID,
PACKAGE BODY: SYS.DBMS_ISNAPSHOT 12.2.2
TABLE: SYS.MLOG$ 12.1.1
owner:SYS, object_type:TABLE, object_name:MLOG$, status:VALID,
TABLE: SYS.MLOG$ 12.2.2
owner:SYS, object_type:TABLE, object_name:MLOG$, status:VALID,
TABLE: SYS.SNAP$ 12.2.2
owner:SYS, object_type:TABLE, object_name:SNAP$, status:VALID,
TABLE: SYS.SNAP$ 12.1.1
owner:SYS, object_type:TABLE, object_name:SNAP$, status:VALID,
PACKAGE: SYS.DBMS_UTILITY 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_UTILITY, status:VALID,
PACKAGE: SYS.DBMS_UTILITY 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_UTILITY, status:VALID,