No relationships on oracle-9i DB

  • Mel

    Mel - 2010-05-03

    I ran schemaSpy on a remote oracle 9i db and it reported that there are no relationships on the 'relationships' tab. I'm certain that there are relationships in the schema. pls advice.

  • John Currier

    John Currier - 2010-05-04

    I've seen that issue before with MySQL, but not with Oracle.  The first thing is to try the latest beta version.

    If you google for

    oracle list foreign keys

    you should find a few sites that give the SQL required to list your foreign keys.  If that shows foreign key relationships then the problem is in how SchemaSpy is querying that metadata.  If it doesn't show foreign key relationships then SchemaSpy is reporting its findings correctly.


  • PAscal

    PAscal - 2011-05-04

    if there is really no relationships (FK) implemented, you can always use Reverse snowflake joins ( Revj code on sourceforge) or the demo site

    It generates ER Diagramms from sql statements (not DDL)



Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

No, thanks