The Data Dictionary views for Oracle 10g are found in this Reference Guide.
All views that start with USER_ let the user see information about their objects. For instance, USER_TABLES shows their tables. The views that start with ALL_ show the user's objects they own and objects they have access to. The views that start with DBA_ show all objects in the database; as such, you need DBA privileges to see these views.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.