DBA_MVIEW_COMMENTS displays comments on all materialized views in the database. Its columns are the same as those in ALL_MVIEW_COMMENTS.
· ALL_MVIEW_COMMENTS displays comments on the materialized views accessible to the current user.
· USER_MVIEW_COMMENTS displays comments on the materialized views owned by the current user. This view does not display the OWNER column.
| Column | Datatype | NULL | Description |
|
|
|
| Owner of the materialized view |
|
|
|
| Name of the materialized view |
|
|
| | Comment on the materialized view |
Oracle data dictionary views
Oracle dynamic performance views
No comments:
Post a Comment