Oracle 8.1.7 to MySQL still has issues with Views

[Tiberiu Fustos]

Hi,

I noticed this same issue described in another post for version 1.0.7 of the migration toolkit - it was mentioned that it will be addressed - I used the latest 1.0.9beta and it still seems to have issues with reading the views from Oracle 8:

-> failure during reverse engineering, while trying to read the views (the tables are read OK):

-------------------------------
Fetch all views of the schema STATIC_CONTENT.
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)
[...]

-------------------------------

-->> one more note: I use the ojdbc14.jar JDBC driver instead of the one supplied with Oracle 8 (the migration toolikit failed to read the classes12.zip file).

Any ideas what could be the issue?

Thanks,
Tibi



Edited 2 time(s). Last edit at 07/02/2005 06:05PM by Tiberiu Fustos.