DBA Data[Home] [Help]

VIEW: SYS.ALL_REPKEY_COLUMNS

Source

View Text - Preformatted

select r.sname, r.oname, r.col
from sys.dba_repkey_columns r, all_repobject ro
where r.sname = ro.sname
  and r.oname = ro.oname
  and ro.type IN ('TABLE', 'SNAPSHOT')
View Text - HTML Formatted

SELECT R.SNAME
, R.ONAME
, R.COL FROM SYS.DBA_REPKEY_COLUMNS R
, ALL_REPOBJECT RO WHERE R.SNAME = RO.SNAME
AND R.ONAME = RO.ONAME
AND RO.TYPE IN ('TABLE'
, 'SNAPSHOT')