All of the views listed in this section actually have three varieties, which are identified
by their prefixes:
DBA_
Includes all the objects in the database. A user must have DBA privileges to use
this view.
USER_
Includes only the objects in the user??™s own database schema.
Data Dictionary Tables | 121
ALL_
Includes all the objects in the database to which a particular user has access. If a
user has been granted rights to objects in another user??™s schema, these objects
will appear in this view.
This means that, for instance, there are three views that relate to tables: DBA_
TABLES, USER_TABLES, and ALL_TABLES.
Some of the more common views that directly relate to the data structures are
described in Table 4-2.
Table 4-2. Data dictionary views about data structures
Data dictionary view Type of information
ALL_TABLES Information about the object and relational tables
TABLES Information about the relational tables
TAB_COMMENTS Comments about the table structures
TAB_HISTOGRAMS Statistics about the use of tables
TAB_PARTITIONS Information about the partitions in a partitioned table
TAB_PRIVS* Different views detailing all the privileges on a table, the privileges granted by the user, and the
privileges granted to the user
TAB_COLUMNS Information about the columns in tables and views
COL_COMMENTS Comments about individual columns
COL_PRIVS* Different views detailing all the privileges on a column, the privileges granted by the user, and the
privileges granted to the user
LOBS Information about large object (LOB) datatype columns
VIEWS Information about views
INDEXES Information about the indexes on tables
IND_COLUMNS Information about the columns in each index
IND_PARTITIONS Information about each partition in a partitioned index
PART_* Different views detailing the composition and usage patterns for partitioned tables and indexes
CONS_COLUMNS Information about the columns in each constraint
CONSTRAINTS Information about constraints on tables
SEQUENCES Information about sequence objects
SYNONYMS Information about synonyms
TAB_COL_STATISTICS Statistics used by the cost-based analyzer
TRIGGERS Information about the triggers on tables
TRIGGER_COLS Information about the columns in triggers
122
Chapter 5 CHAPTER 5
Managing Oracle 5
Many Oracle users and developers are not actively aware of the system and database
management activities that go on around them.
Pages:
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282