Operating System - HP-UX
1748232 Members
3480 Online
108759 Solutions
New Discussion юеВ

data relationalship in Oracle

 
SOLVED
Go to solution
Stephen Badgett
Regular Advisor

data relationalship in Oracle

Hello

I need to build a diagram showing the relationalship of the data items in the database somewhat like what I have seen in MS Access. Is there a way I can pull this information out of the Oracle database? I am using 9i r2 currently.

Steve
Not as is, is now
7 REPLIES 7
Joseph Loo
Honored Contributor

Re: data relationalship in Oracle

hi,

do you have Oracle Enterprise Manager (OEM)? this should show u some data objects linkages, if that is what u require.

regards.
what you do not see does not mean you should not believe
Sanjay Kumar Suri
Honored Contributor
Solution

Re: data relationalship in Oracle

As previous post has suggested, you can do the following with OEM. You can launch OEM from Windows platform can can connect to Oracle servers running on other server.

1. Administer the complete Oracle environment, including databases, iAS servers, applications, and services.
2. Diagnose, modify, and tune multiple databases.
3. Schedule tasks on multiple systems at varying time intervals.
4. Monitor database conditions throughout the network.
5. Administer multiple network nodes and services from many locations.
6. Share tasks with other administrators.
7. Group related services together to facilitate administration tasks.
8. Launch integrated Oracle and third-party tools.

sks
A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.
Nicolas Dumeige
Esteemed Contributor

Re: data relationalship in Oracle

Hello,

A colleugue have done it with AMC designor by reverse ingeenering.

Cheers

Nicolas
All different, all Unix
H├еkon W├╕ien
Occasional Contributor

Re: data relationalship in Oracle


A very handy tool is the DBVisualizer from Minq Software. Take a look at http://www.minq.se/products/dbvis. With this tool you can see the relations between tables.

Regards,
H├Г┬еk
Fred Ruffet
Honored Contributor

Re: data relationalship in Oracle

If you want to play, build your own with the 2 sys views :
dba_tables
dba_constraints
:)

Seriously, can't you do it by linking the Oracle tables in MS Access ?

Regards,

Fred
--

"Reality is just a point of view." (P. K. D.)
R. Allan Hicks
Trusted Contributor

Re: data relationalship in Oracle

Oracle's designer can do reverse engineering of the data base to give you a physical model.

You might try the 30 day trial version of designer from

http://otn.oracle.com/software/products/designer/index.html

It can be a bit of a pain to install, but it's relatively easy to use.

"Only he who attempts the absurd is capable of achieving the impossible
Fred Ruffet
Honored Contributor

Re: data relationalship in Oracle

I did forgot this one :
ER Studio from Emarcadero (http://www.embarcader.co.uk/)

Quite good reverse engineering program, that can come with the execellents DBArtisan and Rapid SQL.

Regards,

Fred
--

"Reality is just a point of view." (P. K. D.)