RE: what is the data dictionary?

  • From: "Michael McMullen" <ganstadba@xxxxxxxxxxx>
  • To: <martin.a.berger@xxxxxxxxx>
  • Date: Wed, 23 Sep 2009 15:19:32 -0400

That Ada Lovelace quote was pretty funny.

How about "select * from dictionary" to list the tables/views or "select *
from dict"

But isn?t this question like asking "What is the Airspeed Velocity of an
Unladen Swallow"

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Martin Berger
Sent: Wednesday, September 23, 2009 3:10 PM
To: Goulet, Richard
Subject: Re: what is the data dictionary?

Hi Dick,

thank you for this more useful answer.
I checked also the other emails and will summarise them:

Some others just call the Data Dictionary "metadata", but nothing more

I also get the info it's bad habit to put objects into sys schema.

Your hint to sql.bsq is the most useable until now. As you call the
objects created there "basic data dictionary" - is there an "extended
data dictionary"?

There are also some dinosaurs (most of them might have discussed
methods with Ada Lovelace) chatting in this thread.

Unfortunately, noone can tell me how to decide for sure if an object
(let's say by object_id) is part of the data dictionary or not. (not
to mention the data dictionary cache)



Other related posts: