Tables, clusters, and views
These views provide information about tables, clusters, and views:
- DBA_ALL_TABLES
Lists all object and relational tables.
- DBA_CLU_COLUMNS
Lists all cluster keys.
- DBA_CLUSTER_HASH_EXPRESSIONS
Lists the hash values used for the optional cluster hash indexes.
- DBA_CLUSTERS
Lists all clusters in the database.
- DBA_COL_COMMENTS
Shows comments on all table and view columns.
- DBA_TAB_COL_STATISTICS
Contains column information about analyzed columns. This is a subset of the information available in DBA_TAB_COLUMNS.
- DBA_TAB_COLUMNS
Shows all table and view columns.
- DBA_TAB_COMMENTS
Shows all comments on tables and views.
- DBA_TAB_HISTOGRAMS
Shows all table histograms.
- DBA_TABLES
Shows all relational tables.
- DBA_UPDATABLE_COLUMNS
Lists columns in views with joins that can be updated.
- DBA_VIEWS
Shows all views.
Get Oracle Database Administration: The Essential Refe 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.