Table:
Some essential Oracle System Tables
| Table |
Description |
| ALL_CATALOG |
All tables, views, synonyms, sequences accessible to the user |
| ALL_INDEXES |
Descriptions of indexes on tables accessible to the user |
| ALL_OBJECTS |
Objects accessible to the user |
| ALL_OBJECT_TABLES |
Description of all object tables accessible to the user |
| ALL_TABLES |
Description of relational tables accessible to the user |
| ALL_TRIGGERS |
Triggers accessible to the current user |
| ALL_TYPES |
Description of types accessible to the user |
| ALL_UPDATABLE_COLUMNS |
Description of all updatable columns |
| ALL_USERS |
Information about all users of the database |
| ALL_VIEWS |
Description of views accessible to the user |
| DBA_OBJECTS |
All objects in the database |
| DBA_ROLES |
All Roles which exist in the database |
| DBA_ROLE_PRIVS |
Roles granted to users and roles |
| DBA_SOURCE |
Source of all stored objects in the database |
| DBA_TABLESPACES |
Description of all tablespaces |
| DBA_TAB_PRIVS |
All grants on objects in the database |
| DBA_TS_QUOTAS |
Tablespace quotas for all users |
| DBA_USERS |
Information about all users of the database |
| DBA_VIEWS |
Description of all views in the database |
| DICTIONARY |
Description of data dictionary tables and views |
| GLOBAL_NAME |
global database name |
| PRODUCT_COMPONENT_VERSION |
Version and status information for component products |
| SESSION_PRIVS |
Privileges which the user currently has set |
| SESSION_ROLES |
Roles which the user currently has enabled. |
| SYSTEM_PRIVILEGE_MAP |
Maps privilege type numbers to type names |
