Data Dictionary of Oracle 11g



Index | Home | Forums

Table Name Description
ALL_BASE_TABLE_MVIEWS All materialized views with log(s) in the database that the user can see

Column ID Column name Data type Length Precision NULL Description
1OWNERVARCHAR230(null)NOwner of the master table which changes are logged
2MASTERVARCHAR230(null)NName of the master table which changes are logged
3MVIEW_LAST_REFRESH_TIMEDATE7(null)NOne date per materialized view -- the date the materialized view was last refreshed
4MVIEW_IDNUMBER2238YUnique identifier of the materialized view

Index | Home | Forums

This page was created by oracleabc.com on Dec 31,2007 18:49:19
General comments and questions regarding this document should be sent by email to info@oracleabc.com or post your comments here