Results 1 to 5 of 5
  1. #1
    Join Date
    May 2006
    Posts
    24

    Unanswered: A graphical look!?

    Hello,

    I need to have a graphical diagram of my schema in the Oracle 9i and 10g.

    How can I generate such thing?!

  2. #2
    Join Date
    May 2006
    Posts
    18
    Hi,

    If I understand you correctly and provided you have, say, Toad installed, then "ER diagram" feature might be what you're looking for.
    Last edited by Shurik12; 05-13-06 at 09:07.

  3. #3
    Join Date
    May 2006
    Posts
    24
    What is Toad?

    Yes I need an ER diagram but does ORACLE provide this to me?!
    Look, I have a database which has been defined by some other developer. Now, I need a map to be able to study this database.

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    This is TOAD (Tool for Application Developers).

    If you installed Oracle Designer, I *think* that there is an option which allows you to reverse-engineer your database into the repository which will then allow you to display ER diagram.

  5. #5
    Join Date
    Aug 2004
    Location
    France
    Posts
    754
    TOAD and Oracle Designer are not free though...

    I personally use DBDesigner which is free and can reverse engineer your Oracle database. You'll find it here. However, you'll notice that it is aimed at MySQL, so the Oracle datatypes will be mapped to MySQL datatypes... If you don't plan to use it to re-create objects in your Oracle database, it will be sufficient IMO.

    HTH & Regards,

    rbaraer
    ORA-000TK : No bind variable detected... Shared Pool Alert code 5 - Nuclear query ready .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •