Re: Reverse Engineering and selecting specific tables

Have you checked Oracle's Application Documentation. Last time I checked, Oracle strongly discouraged using the base tables directly for several reasons:

• there are a whole pile of them;
• they reserve the right to change them;
• you will likely disable the support contract.

They do provide a commented data dictionary in their TRM (Technical Reference Manual) available to licensed organizations to enable exactly what you want. The accesses are by view on the relevant tables.

Check your Oracle sales rep for access to the TRM.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** Top posting guarantees I will not respond further ***