The data dictionary is created when you initially create the database with the CREATE DATABASE command. The data dictionary tables are owned by SYS and are accessed through DBA_, ALL_ and USER_ views. If you want to know what is in your data dictionary, query the appropriate views. Never update the data dictionary manually! Let the database update it when you issue CREATE, ALTER or DROP commands.
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.