Oracle 9i Fundamentals I Exam Cram 2

You can get information, naturally, out of the data dictionary concerning tables. This information can be used to assist in documenting the database, or to help the DBA find the locations and attributes of the tables in your database. Table 12.2 gives you the most useful data dictionary views and the kind of information that they will help you find.

Table 12.2. Data Dictionary Views for Tables

View

Description

DBA_TABLES

Provides information on relational tables. Included are storage information, tablespace location, space utilization information, and table type.

DBA_TAB_COLS

Provides all table and view columns.

DBA_TAB_COMMENTS

Shows all the comments on tables and views.

DBA_COL_COMMENTS

Shows all the comments on all the columns.

DBA_EXTERNAL_TABLES

Describes the attributes, including the directory name and owner for external tables.

DBA_TAB_COL_STATISTICS

Provides information on analyzed columns.

DBA_CLUSTERS

Provides information on all the clusters in the database, including the name, tablespace, and owner.

    Related

    Категории