There are a couple of tables that will make your life easier and not make you feel so blind and helpless. This is by no means a complete list, just a couple good ones to get you on your way poking about and learning the lay of the land.
| 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 |