Data Dictionary Tablespace and Data File Information
Tablespace information can be found in the data dictionary in the views that you can find in Table 10.1. Table 10.1 is a list of data dictionary views along with a brief description of the information that can be found through those views.
| View | Description |
|---|---|
| V$TABLESPACE | Provides the name and number of tablespaces. |
| DBA_TABLESPACES | Provides descriptions of all tablespaces. |
| USER_TABLESPACES | Provides descriptions of all the given user's accessible tablespaces. |
| DBA_SEGMENTS | Provides information about segments associated with all tablespaces. |
| USER_SEGMENTS | Provides information about segments owned by the given user's accessible tablespaces. |
| DBA_EXTENTS ... |
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.
