The static data dictionary views have existed in their current format since Oracle Version 6. These are views owned by SYS that are built upon tables owned by SYS and give you the ability to find information about database objects. Table 14.2 shows which static data dictionary views should be used to find specific types of information.
If You Need to Find Information About... |
Use These Data Dictionary Views |
Objects owned by you |
Views that begin with USER_ |
Objects to which you have been granted access |
Views that begin with ALL_ |
All objects in the database |
Views that begin with DBA_ |
Tables |
DBA_TABLES DBA_NESTED_TABLES DBA_OBJECT_TABLES DBA_PART_TABLES DBA_TAB_COMMENTS DBA_TAB_PARTITIONS DBA_TAB_HISTOGRAMS |
Columns |
DBA_CLU_COLUMNS DBA_COLL_TYPES DBA_COL_COMMENTS DBA_COL_PRIVS DBA_CONS_COLUMNS DBA_IND_COLUMNS DBA_TAB_COL_STATISTICS DBA_TAB_COLUMNS DBA_TRIGGER_COLS DBA_UPDATABLE_COLUMNS |
Views |
DBA_VIEWS |
Tablespaces |
DBA_TABLESPACES DB_TS_QUOTAS DBA_DATA_FILES |
Constraints |
DBA_CONSTRAINTS DBA_CONS_COLUMNS |
Indexes |
DBA_INDEXES DBA_IND_COLUMNS DBA_PART_INDEXES DBA_IND_PARTITIONS |
Auditing |
DBA_AUDIT_TRAIL DBA_AUDIT_SESSION DBA_EXITS DBA_AUDIT_OBJECT DBA_AUDIT_STATEMENT |
Procedures/packages |
DBA_SOURCE ALL_ARGUMENTS DBA_ERRORS DBA_OBJECT_SIZE DBA_LIBRARIES PUBLIC_DEPENDENCIES |
Snapshots |
DBA_REGISTERED_SNAPSHOTS DBA_SNAPSHOT_LOGS DBA_SNAPSHOT_REFRESH_TIMES DBA_SHAPSHOT_LOG_FILTER_COLS DBA_SNAPSHOTS |
Sequences |
DBA_SEQUENCES |