VIEW: SYS.ALL_REGISTERED_MVIEWS

Source

View Text - Preformatted

select  "OWNER","NAME","MVIEW_SITE","CAN_USE_LOG","UPDATABLE","REFRESH_METHOD","MVIEW_ID","VERSION","QUERY_TXT" from dba_registered_mviews s
where exists (select a.mview_id from all_base_table_mviews a
                             where  s.mview_id = a.mview_id)
or  userenv('SCHEMAID') = 1
or  exists (select null from v$enabledprivs
            where priv_number  in (-45 /* LOCK ANY TABLE */,
                                   -47 /* SELECT ANY TABLE */,
                                   -397/* READ ANY TABLE */,
                                   -48 /* INSERT ANY TABLE  */,
                                   -49 /* UPDATE ANY TABLE */,
                                   -50 /* DELETE ANY TABLE */)
            )

View Text - HTML Formatted

SELECT "OWNER"
, "NAME"
, "MVIEW_SITE"
, "CAN_USE_LOG"
, "UPDATABLE"
, "REFRESH_METHOD"
, "MVIEW_ID"
, "VERSION"
, "QUERY_TXT"
FROM DBA_REGISTERED_MVIEWS S WHERE EXISTS (SELECT A.MVIEW_ID
FROM ALL_BASE_TABLE_MVIEWS A
WHERE S.MVIEW_ID = A.MVIEW_ID) OR USERENV('SCHEMAID') = 1 OR EXISTS (SELECT NULL
FROM V$ENABLEDPRIVS
WHERE PRIV_NUMBER IN (-45 /* LOCK ANY TABLE */
, -47 /* SELECT ANY TABLE */
, -397/* READ ANY TABLE */
, -48 /* INSERT ANY TABLE */
, -49 /* UPDATE ANY TABLE */
, -50 /* DELETE ANY TABLE */) )