Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Data dictinary for all tables

Posted on 2006-04-25
Medium Priority
Last Modified: 2008-01-09
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.

Question by:KG1973
  • 2
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 16534678
join ALL_TABLES with the ALL_TAB_COLUMNS to get the columns of the tables.

LVL 143

Accepted Solution

Guy Hengel [angelIII / a3] earned 300 total points
ID: 16534683

Assisted Solution

fouaddba earned 450 total points
ID: 16534787
DBA/ALL_TABLES       >     Description of all relational tables in the database
DBA/ALL_TAB_COLUMNS     >  Columns of user's tables, views and clusters

basically if u r only looking for columns info. DBA/ALL/USER_TAB_COLUMNS is sufficeint

but if u want INDEXES & CONSTRAINTS too

then u need to join all_indexes + all_ind_columns        > to get complete index info.
and dba_constraints + dba_cons_columns                   > to get complete picture for constraints

basically what I suggest over here that first u should check what you owner has, e.g.,

select object_name, object_type, ... if u want some more
from dba/all_objects          > according to ur privs
where owner= 'SCOTT'

this'll give u a complete picture of ur user ownership, then only u can start working,
and one more Erwin is more appropriate to do reverse engineering.

hope this helps!
LVL 19

Expert Comment

ID: 16534862
also, you might need to check:

to see all comments made before.

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

577 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question