VIEW: SYSTEM.MVIEW_EXCEPTIONS

Source

View Text - Preformatted

select
  t1.runid# as runid,
  owner,
  table_name,
  dimension_name,
  relationship,
  bad_rowid
from SYSTEM.MVIEW$_ADV_EXCEPTIONS t1, SYSTEM.MVIEW$_ADV_LOG t2, ALL_USERS u
where
  t1.runid# = t2.runid# and
  u.username = t2.uname and
  u.user_id = userenv('SCHEMAID')

View Text - HTML Formatted

SELECT T1.RUNID# AS RUNID
, OWNER
, TABLE_NAME
, DIMENSION_NAME
, RELATIONSHIP
, BAD_ROWID FROM SYSTEM.MVIEW$_ADV_EXCEPTIONS T1
, SYSTEM.MVIEW$_ADV_LOG T2
, ALL_USERS U WHERE T1.RUNID# = T2.RUNID# AND U.USERNAME = T2.UNAME AND U.USER_ID = USERENV('SCHEMAID')