VIEW: SYS.ALL_REPCOLUMN

Source

View Text - Preformatted

select
 r.sname, r.oname, r.type, r.cname, r.id, r.pos, r.compare_old_on_delete,
 r.compare_old_on_update, r.send_old_on_delete, r.send_old_on_update,
 r.ctype, r.ctype_toid, r.ctype_owner, r.ctype_hashcode,
 r.ctype_mod, r.data_length, r.data_precision, r.data_scale, r.nullable,
 r.character_set_name, r.top, r.char_length, r.char_used
from all_tab_columns tc, sys.dba_repcolumn r
where r.sname = tc.owner
  and r.oname = tc.table_name
  and ((r.top IS NOT NULL AND r.top = tc.column_name) OR
       (r.top IS NULL AND r.cname = tc.column_name))
union
select
 r.sname, r.oname, r.type, r.cname, r.id, r.pos, r.compare_old_on_delete,
 r.compare_old_on_update, r.send_old_on_delete, r.send_old_on_update,
 r.ctype, r.ctype_toid, r.ctype_owner, r.ctype_hashcode,
 r.ctype_mod, r.data_length, r.data_precision, r.data_scale, r.nullable,
 r.character_set_name, r.top, r.char_length, r.char_used
from  "_ALL_REPL_NESTED_TABLE_NAMES" nt, sys.dba_repcolumn r
where r.sname = nt.owner
  and r.oname = nt.table_name

View Text - HTML Formatted

SELECT R.SNAME
, R.ONAME
, R.TYPE
, R.CNAME
, R.ID
, R.POS
, R.COMPARE_OLD_ON_DELETE
, R.COMPARE_OLD_ON_UPDATE
, R.SEND_OLD_ON_DELETE
, R.SEND_OLD_ON_UPDATE
, R.CTYPE
, R.CTYPE_TOID
, R.CTYPE_OWNER
, R.CTYPE_HASHCODE
, R.CTYPE_MOD
, R.DATA_LENGTH
, R.DATA_PRECISION
, R.DATA_SCALE
, R.NULLABLE
, R.CHARACTER_SET_NAME
, R.TOP
, R.CHAR_LENGTH
, R.CHAR_USED FROM ALL_TAB_COLUMNS TC
, SYS.DBA_REPCOLUMN R WHERE R.SNAME = TC.OWNER
AND R.ONAME = TC.TABLE_NAME
AND ((R.TOP IS NOT NULL
AND R.TOP = TC.COLUMN_NAME) OR (R.TOP IS NULL
AND R.CNAME = TC.COLUMN_NAME)) UNION SELECT R.SNAME
, R.ONAME
, R.TYPE
, R.CNAME
, R.ID
, R.POS
, R.COMPARE_OLD_ON_DELETE
, R.COMPARE_OLD_ON_UPDATE
, R.SEND_OLD_ON_DELETE
, R.SEND_OLD_ON_UPDATE
, R.CTYPE
, R.CTYPE_TOID
, R.CTYPE_OWNER
, R.CTYPE_HASHCODE
, R.CTYPE_MOD
, R.DATA_LENGTH
, R.DATA_PRECISION
, R.DATA_SCALE
, R.NULLABLE
, R.CHARACTER_SET_NAME
, R.TOP
, R.CHAR_LENGTH
, R.CHAR_USED FROM "_ALL_REPL_NESTED_TABLE_NAMES" NT
, SYS.DBA_REPCOLUMN R WHERE R.SNAME = NT.OWNER
AND R.ONAME = NT.TABLE_NAME