<<Previous Next>>
Oracle - What
is a static data dictionary in Oracle? - April 10, 2009 at
11:00 AM
What is a static data dictionary in
Oracle?
The information in data dictionary can be accessed through data
dictionary views as they are not directly accessible.
Many data dictionary tables have three corresponding views:
- ALL_ view:
In this view, the information accessible to the
current user like the current user's schema and data from objects
in other schemas depending on whether the user has an access to
them.
- DBA_ view:
In this view, all the relevant information in
the entire database is displayed.
DBA_ views are intended only
for administrators. Only by users with the SELECT ANY TABLE
privilege can access them.
This privilege is assigned to the
DBA role when the system is initially installed.
- USER_ view:
In this view, the information from the schema
of the current user is displayed.
No special privileges are
required to query these views..
Also read
Data Dictionary is used to store information about various
physical and logical Oracle structures, e.g.Tables, Tablespaces,
datafiles, etc.........
Data-Dictionary Cache keeps information about the logical and
physical structure of the database...........
|
