Data dictinary for all tables
Posted on 2006-04-25
We have a system developed using Developer 2000 and it was developed by someone which no longer work with our department. The system work with Oracle8 and now we are thinking to migrate to Oracle 10G with new forms. I also want to trace back all tables that are used for this system so that I can redevelop new form (reverse engineering). I noticed that there are tables such as all_users, all_tables, all_views, all_constraint etc.... My question is, where can I find the data dictionary of those tables, describing every columns from every tables, what they are and what purposes. I have tried this sql command "select * from all_tables where owner = 'sam'; and this return all tables associated with this particular user.