Bug #11279 reverse engineering error
Submitted: 13 Jun 2005 8:52 Modified: 8 Jul 2006 9:03
Reporter: Guillaume Vers-Pouy Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Migration Toolkit Severity:S1 (Critical)
Version:1.0.7-beta OS:Windows (XP professionnal)
Assigned to: CPU Architecture:Any

[13 Jun 2005 8:52] Guillaume Vers-Pouy
Description:
During the migration procedure, the "reverse engenering" step fails each time i try to migrate datas, either if the source Oracle database is empty or not !

What should I do?

Many thanks in advance!

How to repeat:
Here's the error message encountered each time :

Initializing JDBC driver ... 
Driver class oracle.jdbc.OracleDriver
Opening connection ... 
Connection jdbc:oracle:thin:ops$gverspou/gverspou@ondh9023:1521:eth
Build simple Oracle datatypes.
Call Oracle stored procedure ANALYZE_SCHEMA for OPS$GVERSPOU.
CALL DBMS_UTILITY.ANALYZE_SCHEMA(?,  'ESTIMATE', 50, 0, 'FOR TABLE')
Fetch the number of tables in the schema OPS$GVERSPOU.
SELECT COUNT(*) AS TABLECOUNT FROM ALL_TABLES WHERE OWNER=? ORDER BY OWNER, TABLE_NAME
Fetching 0 table(s) of the schema OPS$GVERSPOU.
SELECT * FROM ALL_TABLES WHERE OWNER=? ORDER BY OWNER, TABLE_NAME
Fetch all views of the schema OPS$GVERSPOU.
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)
[13 Jun 2005 19:37] Michael G. Zinner
Could you state which version of Oracle you are using? We have tested against 9i and 10g.
[17 Jun 2005 12:51] Guillaume Vers-Pouy
The Oracle version I'm actually tested on is Oracle8i. But the driver works fine with this version.
[6 Jul 2005 4:51] Jorge del Conde
I was unable to reproduce this bug using a random db and Oracle 10g