Oracle Data Dictionary

190 pts.
Tags:
Oracle 10g
Oracle 10g Database
Oracle Data Dictionary
Oracle development
I have a large Oracle 10g database for which I wish to generate a Data Dictionary DOCUMENT as a contractual deliverable. I need something that I can hand to my customer, not just instructions on where to query the system for the same information. Are there commands in Oracle that will format this information in such a way that I may incorporate it into an actual document?

Answer Wiki

Thanks. We'll let you know when a new response is added.

This depends on what you mean by format and the content you are wanting. Using simple sqlplus, you can spool out table and index descriptions, as well as any trigger or stored procedure source code. This can be put into just about any documentation tool and made to look very professional. If you have it available, Oracle Reports can do even more formatting than straight sqlplus, but you have to know more to work with the tool. SQL*Plus can do any of the basic formatting and by pre-defining your queries and formatting statements and placing them in a script (unix, windows, whatever o/s), you can reuse this script to update your documentation for this and future contracts……. or you could always find a 3rd party tool to do it for you.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

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

Forgot Password

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

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

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

Thanks! We'll email you when relevant content is added and updated.

Following