Main Tutorials

Create ERD with Visio 2003 + Oracle 11g, reverse engineer failed?

Problem

In Office Visio 2003, trying to use reverse engineer, “Oracle server” as Visio driver to create entity-relationship diagram or ERD from Oracle 11G.

But, when Visio “Extracting Oracle Object, type and body ?XDB$Complex_derivation….” A “Encountered a fatal error during reverse engineer of information from database” message is prompt and the process is stopped.

Solution

Look like the default Visio 2003 Oracle driver is unable to process some of the Oracle 11g objects found in the reverse engineer process, may be some 11g features are too new for Visio 2003?

However, the workaround is choose the “ODBC Generic Driver“, instead of “Oracle Server” as the Visio connector driver, see figure below :

visio-reverse-engineer

Done, now, the Visio 2003 is able to generate ERD via reverse engineer from Oracle 11g.

About Author

author image
Founder of Mkyong.com, love Java and open source stuff. Follow him on Twitter. If you like my tutorials, consider make a donation to these charities.

Comments

Subscribe
Notify of
2 Comments
Most Voted
Newest Oldest
Inline Feedbacks
View all comments
marjna
11 years ago

Indeed
My country is sanctioned
And I can not buy the book world
I can only do it from the Internet and public papers

marjna
11 years ago

hi
a m computer engineer from iran
in my contury oracle in not common
and i want to learn it
pzl helm me
thnks.