Re: Migrating to MySQL 5

[Igor Skybenko]

Well, I tried a new version of Migration Toolkit and it failed on Reverse Engineering. Displayed the following:
Fetch all views of the schema GEB_SUCHE_PROD.
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).
Ungültiger Spaltenname

I tried to use exact ojdbc14.jar as it was suggested, but no effects.
Thanks for quicj feedback!