eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.ALL_REGISTERED_MVIEWS

Object Details

Object Name:	ALL_REGISTERED_MVIEWS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Remote materialized views of local tables that the user can see

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OWNER	VARCHAR2	(128)	Yes	Owner of the materialized view
NAME	VARCHAR2	(128)	Yes	The name of the materialized view
MVIEW_SITE	VARCHAR2	(128)	Yes	Global name of the materialized view site
CAN_USE_LOG	VARCHAR2	(3)		If NO, this materialized view is complex and cannot fast refresh
UPDATABLE	VARCHAR2	(3)		If NO, the materialized view is read only
REFRESH_METHOD	VARCHAR2	(11)		Whether the materialized view uses rowid or primary key or object id for fast refresh
MVIEW_ID	NUMBER			Identifier for the materialized view used by the master for fast refresh
VERSION	VARCHAR2	(26)		Version of materialized view
QUERY_TXT	LONG	(0)		Query defining the materialized view

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      NAME
,      MVIEW_SITE
,      CAN_USE_LOG
,      UPDATABLE
,      REFRESH_METHOD
,      MVIEW_ID
,      VERSION
,      QUERY_TXT
FROM SYS.ALL_REGISTERED_MVIEWS;

Dependencies

[top of page]

SYS.ALL_REGISTERED_MVIEWS references the following:

SYS: ALL_BASE_TABLE_MVIEWS; DBA_REGISTERED_MVIEWS

SYS.ALL_REGISTERED_MVIEWS is referenced by following:

PUBLIC: ALL_REGISTERED_MVIEWS