!! Please do not post Off Topic to this List !!
Not sure this is what you want.
Joan
set pagesize 24
set linesize 132
col fk_owner format a10
col fk_table format a15
col pk_owner format a10
col pk_table format a15
col fk_col format a15
col pk_col format a15
select fk.owner fk_owner,
fk.table_name fk_table,
fkc.column_name fk_col,
pk.owner pk_owner,
pk.table_name pk_table,
pkc.column_name pk_col
from dba_constraints fk, dba_constraints pk,dba_cons_columns fkc,
dba_cons_columns pkc
where fk.r_constraint_name = pk.constraint_name
and fk.constraint_type = 'R'
and pk.constraint_type='P'
and fk.r_owner=pk.owner
and fk.constraint_name=fkc.constraint_name
and pk.constraint_name=pkc.constraint_name
and fk.owner=fkc.owner
and fk.table_name =fkc.table_name
and pk.owner=pkc.owner
and pk.table_name=pkc.table_name
and pk.owner not in('SYS','SYSTEM')
/
> "Koivu, Lisa" wrote:
>
> Toad. www.toadsoft.com
> Does everything you're asking for.
>
> Lisa Koivu
> Oracle Database Administrator
> Fairfield Resorts, Inc.
> 954-935-4117
>
> -----Original Message-----
> From: John Lewis [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, September 12, 2001 1:25 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Any shareware/gnu ER diagramers out there?
>
> Basically looking for something that reads a schema and prints
> out
> what tables have FK to what other tables. Dependencies also?
>
> I may have a need very soon for one.
>
> Thanks -
>
> John F. Lewis
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: John Lewis
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858)
> 538-5051
> San Diego, California -- Public Internet access / Mailing
> Lists
> --------------------------------------------------------------------
>
> To REMOVE yourself from this mailing list, send an E-Mail message
>
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
> in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You
> may
> also send the HELP command for other information (like
> subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joan Hsieh
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
