Static Data Dictionary Views
The data dictionary views are called static views because they change infrequently,
only when a change is made to the data dictionary. Examples of data dictionary
changes include creating a new table or granting a privilege to a user.
Many data dictionary tables have three corresponding views:
■ A DBA_ view displays all relevant information in the entire database. DBA_ views
are intended only for administrators.
An example of a DBA_ view is DBA_TABLESPACES, which contains one row for each
tablespace in the database.
■ An ALL_ view displays all the information accessible to the current user, including
information from the schema of the current user, and information from objects in
other schemas, if the current user has access to those objects through privileges or
An example of an ALL_ view is ALL_TABLES, which contains one row for every
table for which the user has object privileges.
■ "About Indexes" on page 8-20
Managing Schema Objects 8-25
■ A USER_ view displays all the information from the schema of the current user. No
special privileges are required to query these views.
An example of a USER_ view is USER_TABLES, which contains one row for every
table owned by the user.
... zobacz całą notatkę