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(30) |
NOT NULL |
Owner of the object at the source database |
SOURCE_OBJECT_NAME |
VARCHAR2(30) |
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. |