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.
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.
if there is really no relationships (FK) implemented, you can always use Reverse snowflake joins ( Revj code on sourceforge) or the demo site http://snowflakejoins.com/.
It generates ER Diagramms from sql statements (not DDL)
Log in to post a comment.
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.