لطفا منتظر باشید ...
• Table of Contents• Index• Reviews• Reader Reviews• Errata• AcademicOracle Essentials: Oracle Database 10g, 3rd EditionBy
Publisher: O''ReillyPub Date: February 2004ISBN: 0-596-00585-7Pages: 368
This new edition distills a vast amount of knowledge into an
easy-to-read volume covering the full range of Oracle''s
features and technologies. The book includes an overview of
Oracle 10g, along with recent releases 9i and 8i.
Oracle Essentials 3rd Edition: Oracle Database
10g provides everything you''ll need to install
and run the Oracle databases. If you''re new to Oracle or
upgrading to Oracle 10g, you''ll find this comprehensive
guide essential.
4.10 Data Dictionary Tables
The main purpose of the Oracle data
dictionary is to store data that describes the structure of the
objects in the Oracle database. Because of this purpose, there are
many views in the Oracle data dictionary that provide information
about the attributes and composition of the data structures within
the database.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.
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, ALL_TABLES, and USER_TABLES.Some of the more common views that directly relate to the data
structures are described in Table 4-2.
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 | The statistics used by the cost-based optimizer |
TRIGGERS | Information about the triggers on tables |
TRIGGER_COLS | Information about the columns in triggers |
