The data dictionary views that start with "USER_" let you see the objects you own. To see your tables, query USER_TABLES. To see your indexes, query USER_INDEXES, etc.
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.