topic Re: data relationalship in Oracle in Operating System - HP-UX

data relationalship in Oracle

Stephen Badgett — Wed, 12 May 2004 15:31:11 GMT

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

Re: data relationalship in Oracle

Joseph Loo — Wed, 12 May 2004 23:38:07 GMT

hi,

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

regards.

Re: data relationalship in Oracle

Sanjay Kumar Suri — Wed, 12 May 2004 23:44:37 GMT

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

Re: data relationalship in Oracle

Nicolas Dumeige — Thu, 13 May 2004 03:05:18 GMT

Hello,

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

Cheers

Nicolas

Re: data relationalship in Oracle

Håkon Wøien — Thu, 13 May 2004 05:48:15 GMT

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

Re: data relationalship in Oracle

Fred Ruffet — Thu, 13 May 2004 06:05:05 GMT

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

Re: data relationalship in Oracle

R. Allan Hicks — Thu, 13 May 2004 14:42:12 GMT

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.

Re: data relationalship in Oracle

Fred Ruffet — Fri, 14 May 2004 10:08:43 GMT

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