René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

Table related static dictionary views

dba_tables

dba_tab_columns

dba_all_tables

dba_tab_comments

This view can be used to find the comments that were stored using comment on table.

dba_col_comments

This view can be used to find the comments that were stored using comment on column.

dba_external_tables

dba_external_locations

dba_tab_histograms

dba_tab_statistics

dba_tab_col_statistics

dba_tab_modifications

dba_encrypted_columns

dba_unused_col_tabs

dba_partial_drop_tabs