Re: Is There Any SQL*Plus Command To Display Table Relationships?

Hi all,

Sorry for replying very late...

I have been struggling the databse conversion task from Informix to Oracle.

Anyway, many people have given me very helpful tips to avoid cartesian products. I though there was a SQL*Plus command to avoid it; however, as Daniel pointed out, I have no choice but have to learn the data! The bad thing about the database I've been dealing with is that it's been in operation for more than 15 years and the existing table structures are very complex. In fact, some of them have been no use for years...

Since I don't have much time, I guess I have to try a third-party tool to analyze the database... I hope everything goes okay...

Once again, thanks much!

alea

"Jac" <jacxine_at_yahoo.com> wrote in message news:<a4ifso$3lo2_at_medusa.qualitynet.net>...
> Try using DBA_CONSTRAINTS
> HTH
> Regards
> "G. Pole, P.Eng." <g.pole_at_home.com> wrote in message
> news:p6na8.372664$pa1.87349757_at_news3.rdc1.on.home.com...
> > I have always used Microsoft Access, via an ODBC connection. It's a good
> > graphical tool and easy to use.
> >
> >
> > "aleatory" <aleatory_at_hotmail.com> wrote in message
> > news:a68a4ee0.0202022205.18dc5e3_at_posting.google.com...
> > > Hi,
> > >
> > > I'm looking for SQL*Plus command to display table
> > > relationships. (Primary-Foreign keys, one-to-one,
> > > one-to-many, many-to-many, etc.)
> > >
> > > I usually have no problem when I deal with two or
> > > three tables; however, when I have to deal with more
> > > than four or five tables, I very often produce
> > > cartesian products.
> > >
> > > Desperately need help on joining tables...
> > >
> > > Thanks in advance!
> > >
> > > alea
> >
> >
Received on Sun Feb 17 2002 - 09:42:24 CET