ORA-00942 error when reverse engineering an Oracle Database scheme


we are currently evaluating VPUML Professional and now have trouble
reverse engineering an Oracle Database scheme to JDBC.
The problem is that this fails with an error dialog appearing right after
specifying driver, url, user, etc. stating “Analyze database error”.

In vp.log log I found the following entries:

[Fri Sep 04 08:03:12 CEST 2009] [message] Starting analyzing database…
[Fri Sep 04 08:03:12 CEST 2009] [warning] java.sql.SQLException: ORA-00942: table or view does not exist

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:831)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2496)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2840)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:623)
at v.iujm.i(:207)
at v.iujm.f(:102)
at v.iujm.i(:55)
at v.ewk.d(:67)
at v.iwph.run(:15)

The big question is now: which table??
I tried to use p6spy for sniffing the JDBC calls but this failed due to the fact that I did
not find the classpath from where this sniffer can load his property file …

I have already successfully reverse engineered two databases. I don’t know what is
special about the one giving me this problem …

My Environment:

  • Windows XP SP3
  • VPUML Prof. 7.0 Build sp1_20090815 (no install with JRE)
  • Oracle 10g
  • Oracle JDBC Driver

Thanks for a hint,


Hi Christian,

Thanks for your post. As we support reverse Oracle database and this feature is available in VP-UML Professional Edition, I suggest you try reverse the database directly from Oracle instead of running Instant Reverse for JDBC.

FYI, details about reverse existing database can be found from:

Please let me know if there is any inquiry.

Best regards,
Lilian Wong