Data Dictionary Information on Tables


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.




    Oracle 9i Fundamentals I Exam Cram 2
    Oracle 9i Fundamentals I Exam Cram 2
    ISBN: 0789732653
    EAN: 2147483647
    Year: 2004
    Pages: 244
    Authors: April Wells

    flylib.com © 2008-2017.
    If you may any questions please contact us: flylib@qtcs.net