Related Entries

Useful SQL*Plus headers
Dino eats frog
Oracle with Active Record
When is he free?
Gentle dive into analytic functions

« Yaml and Slideshows
» Inheritance in Oracle 9i

Introduction to Oracle data dictionary

Getting around Oracle

O'ReillyNet: “The master key to Oracle’s data dictionary”.

Pretty decent introductory article. In my opinion, the best way to figure out a database design is by:

  1. Get a list of objects
  2. Identify static tables and study the data in those
  3. Figure out the relations
  4. Look for triggers
  5. Study the unattended batch processes that run
  6. Lastly, look at the UI
  1. I am learning Oracle, so I would appreciate any input from your expertise.


    Posted by: Reynaldo on July 23, 2003 11:53 PM
  2. Hello, I wanna know something abt "Oracle Batch update",
    It will prove useful if u could give some basic buildup on that topic.

    Posted by: Jaiganesh.k Iyer on August 3, 2003 02:06 AM
  3. Please I would like to get the catalogue of the Oracl Data Dictionary

    Posted by: Sankar Natarajan on January 10, 2004 09:52 AM
  4. Hi,

    I have been doing the Database stuff (academically/professionally) for almost past 6 years. I am planning to go for OCP (8i, DBA). In case if you happen to have some previous test papers, please let me know. I'll pay for the postal and photo copy charges, so that you can send them to me. All this only if you are willing to send them to me.
    Thank you,
    PSS: I am currently in Texas.

    Posted by: Srikanth Turaga on February 10, 2004 05:20 PM