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

VIEW: SYS.CDB_REGISTERED_MVIEWS

Object Details
Object Name: CDB_REGISTERED_MVIEWS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Remote materialized views of local tables in all containers

[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, 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
CON_ID NUMBER

container id
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
,      CON_ID
FROM SYS.CDB_REGISTERED_MVIEWS;

Dependencies

[top of page]

SYS.CDB_REGISTERED_MVIEWS does not reference any database object

SYS.CDB_REGISTERED_MVIEWS is referenced by following:

SchemaPUBLIC
SynonymCDB_REGISTERED_MVIEWS