Failure in Reverse Engineering Process - Oracle Migration

[Kevin Webb]

Greetings!

I am getting an ORA-00942: table or view does not exist failure.
The message log shows the ORA-00942 error, and the contents
of the stack trace, but there is no indication on what table the
error was generated.

If I was to assume the last SELECT statement in the log was the
statement that generated the error - then there is a problem with
the Migration Tool because the tables joined in that query do in fact
exist and return results.

SQL> SELECT v.*, c.STATUS as CHECK_ENABLED FROM ALL_VIEWS v, ALL_CONSTRAINTS c WHERE v.OWNER='LDBU' AND
2 c.TABLE_NAME(+)=v.VIEW_NAME AND c.CONSTRAINT_TYPE(+)='V'ORDER BY v.OWNER, v.VIEW_NAME;

...

18 rows selected.

--Message Log--

SELECT v.*, c.STATUS as CHECK_ENABLED FROM ALL_VIEWS v, ALL_CONSTRAINTS c WHERE v.OWNER=? AND c.TABLE_NAME(+)=v.VIEW_NAME AND c.CONSTRAINT_TYPE(+)='V'ORDER BY v.OWNER, v.VIEW_NAME
The schema could not be reverse engineered (error: 0).
ORA-00942: table or view does not exist

Details:
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)
oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:420)
oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:896)
oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:452)
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:986)
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2888)
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2929)
com.mysql.grt.modules.ReverseEngineeringOracle.reverseEngineerProcedures(Unknown Source)
com.mysql.grt.modules.ReverseEngineeringOracle.reverseEngineer(Unknown Source)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
com.mysql.grt.Grt.callModuleFunction(Unknown Source)



My source Oracle instance is version 8.1.7. I see 9i/10g on the "Source Connection
Screen", but I also saw 8/9/10 on your demo video "Source Connection Screen."


BTW - The message log also contains numerous error statements that
look like internal tool errors to me -

Fetching column information.
SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER=? AND TABLE_NAME=? ORDER BY COLUMN_ID
ERROR: Invalid column name

This query works without error:

SQL> SELECT * FROM ALL_TAB_COLUMNS WHERE OWNER='ADONE' AND TABLE_NAME='TMP_LID' ORDER BY COLUMN_ID;

no rows selected



Thank you.


KFW