Today I tried some reverse engineering tools like ERWin or Toad Data Modeler searching for an alternative for Oracle Designer.
For fun and as a test case, I tried to reverse engineer the XDB schema of an Oracle 11.1.0.6.0 database. Hoping to get some useful information like an Enhanced Relationship Diagram (ERD).
Despite Toad Data Modeler is not yet compatible with the Oracle 11gR1 syntax, I am impressed. Create statements are not correct, overall, but the general result is not bad for a software product that is not up to speed with Oracle latest database version (11gR1).
The result can be seen and queried here: Physical model XDB Schema Oracle 11gR1
Not much relations to be seen though, in the XDB database schema.
😉
