0

Hello All,

I have a sorta unusual problem (not too sure where to post it either), it goes like this:

I am currently using MS Visio 2007 to Reverse Engineer some tables in an Oracle database, MS Visio lists the tables using unprintable characters (lots of little squares). Because of this I am unable to read the listing of table and view names.

Any guidance will be greatly appreciated.

Thanks much.
May

3
Contributors
5
Replies
6
Views
5 Years
Discussion Span
Last Post by debasisdas
0

If you have access to an Oracle database,
can't you go into the database using some sort of tool
(SQL*Plus, SQL Developer, PL/SQL Developer, TOAD, etc.)
and just look at the schema in question?

0

Hi,

I do use TOAD and I am able to look at the schema in question using that. The reason for using the MS Visio Reverse Engineer feature is so that I can create an ERD for the application using the relevant tables (this schema has a lot of tables not pertaining to my application).

May

0

Ok, thanks much though.

I am using the Relationship feature in MS Access to import that tables, but it only does that...allow me to create the relationships and doesn't show the PKs...

0

MS Visio usually displays all the table of the database. You need to select tables related to your schema only. Tables of all other schemas will be qualified by respective schema names.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.