Reverse Engineering with Oracle 10

[dufy]

Hi everybody

I try do do some reverse engineering with the enterprise architect trial version.

The main goal is just to create an er-diagramm from an existing oracle 10 database schema. I managed to connect to the database using Microsoft ODBC driver as described in the enterprise help files.

The result is that I only see the sequences, trigger, functions etc. so everything but the tables.

Does anyone have an idea what I am doing wrong or is the trial version not able to show the tables?

Thanks tom

[Takeshi K]

Hello Tom,

You need to use ODBC driver of Oracle, not Microsoft. EA does not work fine in various cases with Microsoft driver.

Hope this helps.

--
t-kouno

[«Midnight»]

And make sure you are using a fairly recent build of the Oracle client software. Some people have reported problems with older versions. [I last saw this some months or perhaps a year ago, and the then-current client version solved the problem.]

[dufy]

Thanks so far for helping.

I installed the Oracle ODBC-Driver 10102 and managed to get a connection. But as I tried to retrieve the list of objects with the Import DB schema from ODBC source it says "Unable To Obtain Table Information".

It is strange because with the Microsoft ODBC Driver for Oracle I get at least Triggers, Stored Procedures and Sequences.

Our Oracle-DB Version is 10102 and I thought it fits best installing the suitable ODBC-Driver. I will also try it with the version 11.

Thanks dufy