Hi -- Is there any table which stores inturn all the names/metadata of the dictionary tables (ex:sys.objects)? I know there is a table in Oracle called DICTIONARY for this purpose.
The purpose of this DICTIONARY table in Oracle is to maintain the information of all the dictionary tables. Lets say if you want to look at the dictionary table names which has USER as a part of the name, then we can use the following query to view.
SELECT TABLE_NAME FROM DICTIONARY WHERE TABLE_NAME LIKE '%USERS%'; -- The result of this query would be the name of all the dictionary tables which has USER as a part of its name.
This way i can query the dictionary table in Oracle to view information of any dictionary related table.