[Home] [Help] [Dependency Information]
Object Name: | ALL_APPLY_INSTANTIATED_OBJECTS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Details about objects instantiated for the user
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SOURCE_DATABASE | VARCHAR2 | (128) | Yes | Name of the database where the objects originated |
SOURCE_OBJECT_OWNER | VARCHAR2 | (128) | Yes | Owner of the object at the source database |
SOURCE_OBJECT_NAME | VARCHAR2 | (128) | Yes | Name of the object at source |
SOURCE_OBJECT_TYPE | VARCHAR2 | (11) | Type of the object at source | |
INSTANTIATION_SCN | NUMBER | Point in time when the object was instantiated at source | ||
IGNORE_SCN | NUMBER | SCN lower bound for messages that will be considered for apply | ||
APPLY_DATABASE_LINK | VARCHAR2 | (128) | For remote objects, the database link pointing to the remote database | |
SOURCE_ROOT_NAME | VARCHAR2 | (128) |
Cut, paste (and edit) the following text to query this object:
SELECT SOURCE_DATABASE
, SOURCE_OBJECT_OWNER
, SOURCE_OBJECT_NAME
, SOURCE_OBJECT_TYPE
, INSTANTIATION_SCN
, IGNORE_SCN
, APPLY_DATABASE_LINK
, SOURCE_ROOT_NAME
FROM SYS.ALL_APPLY_INSTANTIATED_OBJECTS;
|
|
|