Member Avatar for bmantri

Hello DBAs,

Any one familar with the ER diagram generation in TOAD. I am able to generate the diagram for one particular table. I need to generate for the whole schema. Can you please help me to find out a way?

Always Thanks,
BMantri

  • 5 Contributors
  • 8 Replies
  • 6K Views
  • 4 Years Discussion Span
  • Latest Post Latest Post by Sid_180108

Dani AI

Generated

If you want a whole-schema ERD in TOAD, use the ER Diagrammer (name and menu vary by version; look for an item like Utilities -> ER Diagrammer or Database -> Reports -> ER Diagram). Filter by Owner to your schema, then add all tables. In options, base relationships on Oracle foreign keys. If some relationships cross owners, run TOAD with privileges that let you read DBA views and enable the option to use DBA instead of ALL_ views so cross-schema FKs are picked up. For very large schemas, consider generating by subject area first (e.g., core tables), then merge submodels to keep diagrams readable.

What looks like "hidden" constraints is often disabled or NOVALIDATE FKs, or system-named ones (SYS_C...). Many diagram generators skip disabled/NOVALIDATE relationships unless you tell them to include them. Verify what the database actually has:

select c.owner, c.table_name, c.constraint_name, c.constraint_type,
       c.status, c.deferrable, c.validated, c.r_owner, c.r_constraint_name
from   all_constraints c
where  c.owner = :SCHEMA
and    c.constraint_type in ('P','R','U')
order  by c.table_name, c.constraint_type;

If the FKs do not exist in the dictionary (e.g., enforced by triggers or only by naming conventions), no ER tool can infer them reliably; you will need to create the FK metadata or model those links manually.

Re Visio: DSN and TNS are different. Create an ODBC DSN using an Oracle ODBC driver, and point that DSN to a TNS alias from tnsnames.ora. Then use Visio Reverse Engineer against that DSN.

Recommended Answers

All 8 Replies

Member Avatar for inzomniac

You need to select a table from which to start from. Kind of like a central table from which Toad will build the relationships out of your entire ER diagram.

First, try checking which one of your tables is the most adequate to start from.

Second, select how many levels of referential tables do you think should be enough for the whole diagram to display (default value "5" is usually fine).

Third, select your display options. Click "Ok".

That's it.

commented: i want the clear steps that means how can we draw E-R diagram for a particular table can u explain step by step +0
Member Avatar for satajju

Hi,

This is fine but There are some hidden constraints with in tables which are not generating in TOAD.Can any one help me in this issue

Member Avatar for debasisdas

what is a hidden constraint ?

try to use MS visio .

Member Avatar for satajju

what is a hidden constraint ?

try to use MS visio .

Hi,

How to connect the MS visio from Database.i am new to these MS visio.It would be helpfull if u can give an overview

Member Avatar for debasisdas

Select ER diagram and you will get a new menu Database. Next select Reverser engineer. Next just follow the steps by providing the database login credentials. You have to create a DSN first.

Member Avatar for satajju

Select ER diagram and you will get a new menu Database. Next select Reverser engineer. Next just follow the steps by providing the database login credentials. You have to create a DSN first.

How to select ER diagram u mean that we need to select generated ER-diagram from TOAD.But i am unable to generate for whole shema .Only it is getting generated for only one table.could you plz suggest how to go on.

One more thing Is this DNS or TNS ?

Member Avatar for debasisdas

the steps i suggested was regarding the use of MSVisio not toad. and you need to create a DSN (data source name).

Member Avatar for Sid_180108

In TOAD, to generate the ER Diagram, Choose the Schema from the Drop down, and then select a table-> press Shift and scroll down( This will select all the tables in that schema) - then click on the ER Diagram ICON present on the Menu. The Generated ER diagram will have all the tables.

I tried and it worked!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.