[Home] [Help] [Dependency Information]
Object Name: | DBA_APPLY_INSTANTIATED_SCHEMAS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Details about schemas instantiated
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SOURCE_DATABASE | VARCHAR2 | (128) | Yes | Name of the database where the schemas originated |
SOURCE_SCHEMA | VARCHAR2 | (128) | ||
INSTANTIATION_SCN | NUMBER | Point in time when the schema was instantiated at source | ||
APPLY_DATABASE_LINK | VARCHAR2 | (128) | For remote schemas, the database link pointing to the remote database | |
SOURCE_ROOT_NAME | VARCHAR2 | (128) | Name of the root database where the schemas originated |
Cut, paste (and edit) the following text to query this object:
SELECT SOURCE_DATABASE
, SOURCE_SCHEMA
, INSTANTIATION_SCN
, APPLY_DATABASE_LINK
, SOURCE_ROOT_NAME
FROM SYS.DBA_APPLY_INSTANTIATED_SCHEMAS;
|
|
|