VIEW: SYS.DBA_APPLY_TABLE_COLUMNS

Source

View Text - Preformatted

(select daoc.object_owner, daoc.object_name, daoc.column_name,
       decode(bitand(ac.property, 1), 1, 'NO', 0, 'YES'),
       decode(bitand(ac.property, 2), 2, 'NO', 0, 'YES'),
       daoc.apply_database_link
  from "_DBA_APPLY_TABLE_COLUMNS_H" daoc, "_DBA_APPLY_OBJECTS" ac
 where daoc.object_owner = ac.object_owner
   and daoc.object_name  = ac.object_name
union
select u.name, o.name, doc.column_name,
       decode(bitand(doc.flag, 1), 1, 'NO', 0, 'YES'),
       decode(bitand(doc.flag, 2), 2, 'NO', 0, 'YES'),
       null
  from sys.streams$_dest_obj_cols doc, sys.obj$ o, sys.user$ u
 where o.obj# = doc.object_number
   and o.owner# = u.user#
   and o.linkname is null
   and doc.dblink is null
   and o.remoteowner is null
union
select o.remoteowner, o.name, doc.column_name,
       decode(bitand(doc.flag, 1), 1, 'NO', 0, 'YES'),
       decode(bitand(doc.flag, 2), 2, 'NO', 0, 'YES'),
       doc.dblink
  from sys.streams$_dest_obj_cols doc, sys.obj$ o
 where o.obj# = doc.object_number
   and o.linkname = doc.dblink
   and o.remoteowner is not null)

View Text - HTML Formatted

(SELECT DAOC.OBJECT_OWNER
, DAOC.OBJECT_NAME
, DAOC.COLUMN_NAME
, DECODE(BITAND(AC.PROPERTY
, 1)
, 1
, 'NO'
, 0
, 'YES')
, DECODE(BITAND(AC.PROPERTY
, 2)
, 2
, 'NO'
, 0
, 'YES')
, DAOC.APPLY_DATABASE_LINK
FROM "_DBA_APPLY_TABLE_COLUMNS_H" DAOC
, "_DBA_APPLY_OBJECTS" AC
WHERE DAOC.OBJECT_OWNER = AC.OBJECT_OWNER
AND DAOC.OBJECT_NAME = AC.OBJECT_NAME UNION SELECT U.NAME
, O.NAME
, DOC.COLUMN_NAME
, DECODE(BITAND(DOC.FLAG
, 1)
, 1
, 'NO'
, 0
, 'YES')
, DECODE(BITAND(DOC.FLAG
, 2)
, 2
, 'NO'
, 0
, 'YES')
, NULL
FROM SYS.STREAMS$_DEST_OBJ_COLS DOC
, SYS.OBJ$ O
, SYS.USER$ U
WHERE O.OBJ# = DOC.OBJECT_NUMBER
AND O.OWNER# = U.USER#
AND O.LINKNAME IS NULL
AND DOC.DBLINK IS NULL
AND O.REMOTEOWNER IS NULL UNION SELECT O.REMOTEOWNER
, O.NAME
, DOC.COLUMN_NAME
, DECODE(BITAND(DOC.FLAG
, 1)
, 1
, 'NO'
, 0
, 'YES')
, DECODE(BITAND(DOC.FLAG
, 2)
, 2
, 'NO'
, 0
, 'YES')
, DOC.DBLINK
FROM SYS.STREAMS$_DEST_OBJ_COLS DOC
, SYS.OBJ$ O
WHERE O.OBJ# = DOC.OBJECT_NUMBER
AND O.LINKNAME = DOC.DBLINK
AND O.REMOTEOWNER IS NOT NULL)