how to find out realtions between tables

Printable View

03-27-2001, 10:11 AM
kuckoo

hello DBA friends,
I have one problem realted to Reversal Database modelling.

My database is on oracle 7.2 on NT . One application in forms 4.5 is already there and I want to make changes in that.

For this I don' have a realtional database model or any other documentation realted to design of that db.
I also don't know how tables are related to each other ?

I want to find which tables are master tables and/or child tables.I have to make database modelling to be presice.
And to build up relational-model.

I have total 345 tables.

One way to do it is check constraints for all the tables using
user_constraints and user_cons_columns view.But it is lengthy.

r there any easy steps in thissolution ? or Is there any other way to do this ?

Thanks

kuckoo
03-27-2001, 10:19 AM
r_sonakiya

You can use Designer2000 tool to generate the ER Diagram or other small exercise is use SQLServer.Just import all your objects using ODBC Link and let SQLServer built the diagram for you....
03-27-2001, 10:20 AM
hinermak

Data Modeling Tool

Kookoo

There is a simple solution to this. Look into a tool called ERWin. This tool has a feature which allows you to reverse engineer a number of different databases into a physical picture that will allow you to see the inter-relationships between all of your tables.

Ken
03-27-2001, 11:17 AM
pando

Well any CASE tools does what you want, it´s the minimum feature for a CASE tool

If you want to use trial products you could use Embarcadero ER Studio, ErWin
If you want o use a *free* one and powerful Oracle Designer, FREE if you dont use it for commercial use and because it does NOT expire
03-27-2001, 11:23 AM
looser

what's the different?

I'm thinking about taking a developer course next semester.

what is the different between the designer and developer2k?

are they the same thing?

thanks
03-27-2001, 11:27 AM
sreddy

Desiger is Data modelling tool to design the application.
Developer is a forms and reports based front end user interface.
03-27-2001, 12:33 PM
anuragmin

I have Oracle Designer Case Dictionary CD and also 2 CD's for Oracle Designer release 6 one of them is a pre configured repository. What is the mail difference between release 6 ,pre configured repository and cas dictionary.

Also how does oracle designer perform viz a viz other tools available. I have used ER Studio and it seems to be a decent tool.

Thanks
Anurag

[Edited by anuragmin on 03-27-2001 at 11:46 AM]