Re: where to find documentation on system objects

One place to look is in the Oracle 8i Reference Manual (The pdf file is called a67790.pdf on Oracle 8.1.5.)

According to this manual (chapter 2), these are the "static data dictionary views".

When you are familiar with the available views, the describe operation in sqlplus is another way to get most of the information about the views you might need. The comments on the views are in dba_col_comments and dba_tab_comments.

Frank Hubeny

orauser_at_my-deja.com wrote:

> Apologies in advance - this is a beginner question! But at
> least I am asking where to find some documentation :-)
>
> I want to find out about tables like all_tables, user_tables,
> user_tab_columns, etc.
>
> Are these all part of the 'data dictionary' or is that term reserved
> for views, etc? If they are part of something else, then what is that
> term?
>
> Which manual should I be looking at?
>
> Many thanks in advance.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Jun 20 2000 - 00:00:00 CDT