DBA Data[Home] [Help]

VIEW: SYS._DBA_APPLY_SOURCE_OBJ

Source

View Text - Preformatted

select
  id, owner, name, decode(type, 2, 'TABLE', 'UNSUPPORTED') type,
  source_db_name, dblink, inst_scn, ignore_scn,
  spare1, inst_external_pos, spare2, spare3, source_root_name
from sys.apply$_source_obj
View Text - HTML Formatted

SELECT ID
, OWNER
, NAME
, DECODE(TYPE
, 2
, 'TABLE'
, 'UNSUPPORTED') TYPE
, SOURCE_DB_NAME
, DBLINK
, INST_SCN
, IGNORE_SCN
, SPARE1
, INST_EXTERNAL_POS
, SPARE2
, SPARE3
, SOURCE_ROOT_NAME FROM SYS.APPLY$_SOURCE_OBJ