Meta tables in Oracle 8i, 9i

[Sunder Poovananathan]

Dear Pencilers,

 

Here is a short list of meta tables available in Oracle db. I remember preparing this for my interview.

Hope would be useful for you guys.

 

 

          

TABLE_NAME	COMMENTS
ALL_ALL_TABLES	Description of all object and relational tables accessible to the user
ALL_ARGUMENTS	Arguments in object accessible to the user
ALL_COLL_TYPES	Description of named collection types accessible to the user
ALL_COL_COMMENTS	Comments on columns of accessible tables and views
ALL_COL_PRIVS	Grants on columns for which the user is the grantor, grantee, owner,
ALL_CONSTRAINTS	Constraint definitions on accessible tables
ALL_CONS_COLUMNS	Information about accessible columns in constraint definitions
ALL_DEPENDENCIES	Dependencies to and from objects accessible to the user
ALL_DIRECTORIES	Description of all directories accessible to the user
ALL_ERRORS	Current errors on stored objects that user is allowed to create
ALL_INDEXES	Descriptions of indexes on tables accessible to the user
ALL_INDEXTYPES	All indextypes available to the user
ALL_IND_COLUMNS	COLUMNs comprising INDEXes on accessible TABLES
ALL_JOIN_IND_COLUMNS	Join Index columns comprising the join conditions
ALL_LIBRARIES	Description of libraries accessible to the user
ALL_OBJECTS	Objects accessible to the user
ALL_OBJECT_TABLES	Description of all object tables accessible to the user
ALL_PROCEDURES	Description of all procedures available to the user
ALL_SEQUENCES	Description of SEQUENCEs accessible to the user
ALL_SOURCE	Current source on stored objects that user is allowed to create
ALL_SOURCE_TABLES	NULL
ALL_SOURCE_TAB_COLUMNS	NULL
ALL_SYNONYMS	All synonyms accessible to the user
ALL_TABLES	Description of relational tables accessible to the user
ALL_TAB_COLS	Columns of user's tables, views and clusters
ALL_TAB_COLUMNS	Columns of user's tables, views and clusters
ALL_TRIGGERS	Triggers accessible to the current user
ALL_TRIGGER_COLS	Column usage in user's triggers or in triggers on user's tables
ALL_TYPES	Description of types accessible to the user
ALL_USERS	Information about all users of the database
ALL_VIEWS	Description of views accessible to the user

 

Cheers,

Sunder

 

[sunder]

Sorry guys,

I prepared in a table format. But got distorted like this. let me try
resending this once again.

Regards,
Sunder

On Mar 23, 10:16 am, "Sunder Poovananathan"

<sunder.poovananat...@googlemail.com> wrote:
> Dear Pencilers,
>
> Here is a short list of meta tables available in Oracle db. I remember
> preparing this for my interview.
> Hope would be useful for you guys.
>

> *TABLE_NAME* *COMMENTS* ALL_ALL_TABLES Description of all

[Sunder Poovananathan]

Hi Guys,

 

I think this is readable. ;-)

 

TABLE_NAME                                                                 COMMENTS
===================================================================================

===================================================================================

 

 

Regards,

Sunder