DBA Data[Home] [Help]

VIEW: SYS.ALL_APPLY_INSTANTIATED_OBJECTS

Source

View Text - Preformatted

select aio."SOURCE_DATABASE",aio."SOURCE_OBJECT_OWNER",aio."SOURCE_OBJECT_NAME",aio."SOURCE_OBJECT_TYPE",aio."INSTANTIATION_SCN",aio."IGNORE_SCN",aio."APPLY_DATABASE_LINK",aio."SOURCE_ROOT_NAME"
  from DBA_APPLY_INSTANTIATED_OBJECTS aio, ALL_APPLY aa
  where aa.apply_database_link = aio.apply_database_link
View Text - HTML Formatted

SELECT AIO."SOURCE_DATABASE"
, AIO."SOURCE_OBJECT_OWNER"
, AIO."SOURCE_OBJECT_NAME"
, AIO."SOURCE_OBJECT_TYPE"
, AIO."INSTANTIATION_SCN"
, AIO."IGNORE_SCN"
, AIO."APPLY_DATABASE_LINK"
, AIO."SOURCE_ROOT_NAME"
FROM DBA_APPLY_INSTANTIATED_OBJECTS AIO
, ALL_APPLY AA
WHERE AA.APPLY_DATABASE_LINK = AIO.APPLY_DATABASE_LINK