O'Reilly had a nice introductory article on The Master Key to Oracle's Data Dictionary: "Oracle's data dictionary views are all based on tables, but the views provide a much more user-friendly presentation of the metadata. For example, to find out the names of all of the relational tables that you own, you can issue the following query: SELECT table_name FROM user_tables;"