1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Oracle Graphical view of all relations between the tables

Discussion in 'Oracle Apps Technical' started by Tobi, Sep 23, 2010.

  1. Tobi

    Tobi Active Member

    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    55
    hi there,

    I'm just using SQLDeveloper from Oracle and I opened our ERP-database.
    I count at least 200 tables and I want to know how these tables are related to each other.

    Have anybody experience with it? Or are there any tools to get a grafical view of it?

    Thanks, Tobi
    (Oracle 9i, OS: WinXP Pro)
     
  2. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    Re: Getting a grafical view of all relations between the tables

    If you are talking about Oracle E-Business Suite, the eTRMs have some ER Diagrams. You should check them out.
     
  3. Tobi

    Tobi Active Member

    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    55
    Hi,

    no, I don't even think that the tool I'm using is called Oracle E-Business Suite. It's called SQLDeveloper and it's a free tool from oracle itself.

    I just want to know how I can reproduce an ER-Model of an existing database.
    Are there any further tools? Or had somebody the same problem?

    Thanks, Tobi
     
  4. Tobi

    Tobi Active Member

    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    55
    Hello? Is there anybody?
     
  5. M_Anas_O

    M_Anas_O Forum Advisor

    Messages:
    95
    Likes Received:
    9
    Trophy Points:
    160
    Location:
    Austria
    HI Tobi,

    What Sadik meant is that if you are looking for tables of Oracle E-Biz Suite in SQLDEveloper then you can use eTRM.
    If your database is for some other application, then its different thing.

    As far as I know, there is no graphical option for your requirement in SQLDeveloper
     
  6. santhoshreddy

    santhoshreddy Starter

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    india
    user dba_constraints view to find relation between tables.