Oracle: some useful data dictionary views

USER_INDEXES
USER_IND_COLUMNS

USER_SEQUENCES
USER_SYNONYMS

USER_TABLES
USER_VIEWS

USER_COL_PRIVS_RECD
USER_COL_PRIVS_MADE

USER_SYS_PRIVS
ROLE_TAB_PRIVS

USER_UNUSED_COL_TABS
USER_CONS_COLUMNS
USER_CONSTRAINTS