List of database and table Properties in Oracle

[parixit]

Hi ,

Please any body, can tell me List of database and table Properties , that
has been given by Oracle, that all user can access ........

under which table they contains all information about Prperties

 

[Smartin]

Hi ,

Please any body, can tell me List of database and table Properties , that
has been given by Oracle, that all user can access ........

under which table they contains all information about Prperties

Hi parixit, I would like to know too, but this question is more likely
to be answered in a group that discusses Oracle. This newsgroup is about
Microsoft Access.

 

[Guest]

Smartin is right, but I'm willing to go OT here.

Run the following SQL in Oracle. It provides a list of of the views that you
can use. Could be around 250 of them if you have normal permissions. Look for
those with names starting with ALL_COL, ALL_IND, ALL_TAB, and ALL_VIEWS and
query them.

select view_name from all_views
where view_name like 'ALL%'
order by 1;