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!

Modeler Display Tables and Relationships ...

SM_WorkMay 15 2013 — edited May 15 2013
Ok, so ... I'm reverse-engineering a section of our DB, so as to draw out the tables and constraints.
(using SQL Dev Version 3.2.20.09.87)

I don't want a logical model, I don't want DDL, I just want a picture ... table-layout with relationship lines.
(a fancier and neater napkin drawing, really)

Ok, so ... I get the table list, I right-click on the "Relational Model" entry and choose "Create Display" ...
And it makes a holy mess of 25 tables. I try to straighten it out. Ugh.
Then I figure, I'll delete the darn thing, and start over manually.

BUT I CANNOT GET RID OF IT.
I thot at one point I had a blank canvas, and started to lay out the the two major branches of those 25 tables ... and then I scroll to another part of the screen ... and there are the darn tables again, AND the views I had also asked it to import ... which have no bearing on laying out the tables.

So then I think, I'll just delete these one-by-one, and I try that and it asks me to verify, do I want this table gone?
And I say, NO ... I do not. I want that table. I just don't want the display any more ... or want said table on the display.

I try in the "Display" section under the relational model to delete THAT "Display[1]" item, but no, every time I say "New Display" there's all the old garbage.

So ... now I am thorougly confused: HOW DO I GET RID OF THE DARN LAYOUT???? While keeping the tables?
What I want is to lay out the tables (because I know intimately how they relate to one another), and then click something, e.g., "Auto-Route"??? ... and have it draw the relation lines, and then I straighten these, and then I am done.

But I cannot figure out what to click. The manual is no help.
All I want is a picture.
I am going to give up and go back to ODBC connector in MS Access, wheren I can just lay out the tables in the relationships window, and I will be done in 10 minutes.

What am I doing wrong?

Thanks for your time.

SM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 12 2013
Added on May 15 2013
2 comments
952 views