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 :
Done, now, the Visio 2003 is able to generate ERD via reverse engineer from Oracle 11g.
Indeed
My country is sanctioned
And I can not buy the book world
I can only do it from the Internet and public papers
hi
a m computer engineer from iran
in my contury oracle in not common
and i want to learn it
pzl helm me
thnks.