Monday, July 06, 2009

Reverse Engineering a Data Model using the Oracle Data Dictionary

Reverse Engineering a Data Model using the Oracle Data Dictionary: "All of the above tables (the USER_* tables) only contain objects defined by the current Oracle user. Oracle also maintains a set of tables of identical structure that start with ALL_*. These show you every object that you have access to, regardless of whether you created that object (e.g., our beloved friend DUAL). Similarly, Oracle provides DBA_* tables that contain info about all users' objects, but this group of tables is only accessible to the database administrator."