RE: what is the data dictionary?

From: Michael McMullen <>
Date: Wed, 23 Sep 2009 15:19:32 -0400
Message-ID: <SNT115-DS210C7B06D2822B2365EF6AA6DB0_at_phx.gbl>

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: [] 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 specific.

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)


Received on Wed Sep 23 2009 - 14:19:32 CDT

Original text of this message