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.
| 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 ... |
Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
