Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Why doesn't SQL Developer show the arrows (relations) between parent and child tables in my Entity R

dariyooshSep 2 2014 — edited Sep 4 2014

Hi,


Oracle version:                     Oracle Database 11g Release 11.1.0.7.0 - 64bit Production

SQL Developer version:        4.0.2.15 - Build 15.21

I have a question about drawing Entity Relationship Diagram with SQL Developer & I would appreciate if you could kindly give me a hand.

I wish to draw an Entity Relationship Diagram in order to view better the relationship among several tables. After searching on google, I found the following interesting article indicating how to do so:

http://www.oracle.com/technetwork/issue-archive/2014/14-may/o34sqldev-2193423.html

(What I need and I try to produce  is the Figure 4 in the above article)

I proceeded exactly as indicated in the article & apparently everything worked pretty well, that is, I got several UML like rectangles showing tables' columns, their data types, primary and
foreign key and the arrows indicating the link between each parent/child table.

Later, I tried to the do the same on a different oracle instance and different database by using the very same procedure. Yet, this time something strange happened. SQL Developer printed on the screen the tables, again,
inside rectangles with types, keys, ... but, there was no arrow showing the link among tables, I just saw on the grid the selected tables but without any association/relation shown (as arrow symbol)
between them.

I repeated the procedure on another development instance, with a few test tables that I created with primary and foreign keys just to make sure that I had followed the procedure correctly. Again

the test was successfull but when I repeated the test on another instance, the same problem persisted, that is, no arrow (relation) between tables.

Any idea?

Could this be due some lack of privilege on the instance? If so, what should be granted in terms of role(s)?

Thanks in advance

This post has been answered by thatJeffSmith-Oracle on Sep 2 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 2 2014
Added on Sep 2 2014
2 comments
2,661 views