Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

Part Number B28320-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF


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.