DBA Data[Home] [Help]

VIEW: SYS.USER_REPDDL

Source

View Text - Preformatted

select r.log_id, r.source, r.role, r.master, r.line, r.text, r.ddl_num
from system.repcat$_ddl r, user_repcatlog u
where r.log_id = u.id
  and r.source = u.source
View Text - HTML Formatted

SELECT R.LOG_ID
, R.SOURCE
, R.ROLE
, R.MASTER
, R.LINE
, R.TEXT
, R.DDL_NUM FROM SYSTEM.REPCAT$_DDL R
, USER_REPCATLOG U WHERE R.LOG_ID = U.ID
AND R.SOURCE = U.SOURCE