VIEW: SYS.USER_MVIEWS

Source

View Text - Preformatted

select m."OWNER",m."MVIEW_NAME",m."CONTAINER_NAME",m."QUERY",m."QUERY_LEN",m."UPDATABLE",m."UPDATE_LOG",m."MASTER_ROLLBACK_SEG",m."MASTER_LINK",m."REWRITE_ENABLED",m."REWRITE_CAPABILITY",m."REFRESH_MODE",m."REFRESH_METHOD",m."BUILD_MODE",m."FAST_REFRESHABLE",m."LAST_REFRESH_TYPE",m."LAST_REFRESH_DATE",m."LAST_REFRESH_END_TIME",m."STALENESS",m."AFTER_FAST_REFRESH",m."UNKNOWN_PREBUILT",m."UNKNOWN_PLSQL_FUNC",m."UNKNOWN_EXTERNAL_TABLE",m."UNKNOWN_CONSIDER_FRESH",m."UNKNOWN_IMPORT",m."UNKNOWN_TRUSTED_FD",m."COMPILE_STATE",m."USE_NO_INDEX",m."STALE_SINCE",m."NUM_PCT_TABLES",m."NUM_FRESH_PCT_REGIONS",m."NUM_STALE_PCT_REGIONS",m."SEGMENT_CREATED",m."EVALUATION_EDITION",m."UNUSABLE_BEFORE",m."UNUSABLE_BEGINNING" from dba_mviews m, sys.user$ u
where u.user# = userenv('SCHEMAID')
  and m.owner = u.name

View Text - HTML Formatted

SELECT M."OWNER"
, M."MVIEW_NAME"
, M."CONTAINER_NAME"
, M."QUERY"
, M."QUERY_LEN"
, M."UPDATABLE"
, M."UPDATE_LOG"
, M."MASTER_ROLLBACK_SEG"
, M."MASTER_LINK"
, M."REWRITE_ENABLED"
, M."REWRITE_CAPABILITY"
, M."REFRESH_MODE"
, M."REFRESH_METHOD"
, M."BUILD_MODE"
, M."FAST_REFRESHABLE"
, M."LAST_REFRESH_TYPE"
, M."LAST_REFRESH_DATE"
, M."LAST_REFRESH_END_TIME"
, M."STALENESS"
, M."AFTER_FAST_REFRESH"
, M."UNKNOWN_PREBUILT"
, M."UNKNOWN_PLSQL_FUNC"
, M."UNKNOWN_EXTERNAL_TABLE"
, M."UNKNOWN_CONSIDER_FRESH"
, M."UNKNOWN_IMPORT"
, M."UNKNOWN_TRUSTED_FD"
, M."COMPILE_STATE"
, M."USE_NO_INDEX"
, M."STALE_SINCE"
, M."NUM_PCT_TABLES"
, M."NUM_FRESH_PCT_REGIONS"
, M."NUM_STALE_PCT_REGIONS"
, M."SEGMENT_CREATED"
, M."EVALUATION_EDITION"
, M."UNUSABLE_BEFORE"
, M."UNUSABLE_BEGINNING"
FROM DBA_MVIEWS M
, SYS.USER$ U WHERE U.USER# = USERENV('SCHEMAID')
AND M.OWNER = U.NAME