2.38 ALL_APPLY_INSTANTIATED_OBJECTS

ALL_APPLY_INSTANTIATED_OBJECTS displays information about objects accessible to the current user for which an instantiation SCN has been set.

Related View

DBA_APPLY_INSTANTIATED_OBJECTS displays information about objects for which an instantiation SCN has been set.

Column Datatype NULL Description

SOURCE_DATABASE

VARCHAR2(128)

NOT NULL

Name of the database where the object originated

SOURCE_OBJECT_OWNER

VARCHAR2(128)

NOT NULL

Owner of the object at the source database

SOURCE_OBJECT_NAME

VARCHAR2(128)

NOT NULL

Name of the object at the source database

SOURCE_OBJECT_TYPE

VARCHAR2(11)

Type of the object at the source database

INSTANTIATION_SCN

NUMBER

Instantiation SCN for the object. Only changes committed after this SCN are applied by an apply process.

IGNORE_SCN

NUMBER

SCN below which the instantiation SCN cannot be set. This value corresponds to the SCN value at the source database at the time when the object was prepared for instantiation.

APPLY_DATABASE_LINK

VARCHAR2(128)

Database link to which changes are applied. If null, then changes are applied to the local database.

SOURCE_ROOT_NAME

VARCHAR2(128)

The global name of the source root database