2.40 ALL_APPLY_INSTANTIATED_SCHEMAS

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

Related View

DBA_APPLY_INSTANTIATED_SCHEMAS displays information about schemas for which an instantiation SCN has been set.

Column Datatype NULL Description

SOURCE_DATABASE

VARCHAR2(128)

NOT NULL

Name of the database where the schema originated

SOURCE_SCHEMA

VARCHAR2(128)

Name of the schema at the source database

INSTANTIATION_SCN

NUMBER

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

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