Q

Creating a data dictionary

We are using Oracle 8i and I am wondering how I can create a data dictionary from our database.
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.
This was first published in February 2004
This Content Component encountered an error

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close