Ask the Expert

Creating a data dictionary

We are using Oracle 8i and I am wondering how I can create a data dictionary from our database.

    Requires Free Membership to View

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: