Re: Oracle 8.1.7 to MySQL still has issues with Views

[Tiberiu Fustos]

Hi Mike,

Thanks for your reply. I would really like to get the migration from Oracle to MySQL done. Nothing special is used - just tables and views.

Ok - I have "DBA" role for the user. The query you asked me to do works, but returns no rows.

Also the other query works (from my previous post) - it even returns the correct views, but for some reason it probably stops at the next step.

If I can enable any special debug options, please let me know and I will do so.

I tried to see with a very simple setup - one table and 1 view - to see if that works.

-> I even have the problem if the schema has no views:

Fetch all views of the schema TIBI.
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.dbaccess.DBError.throwSqlException(DBError.java:168)
oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:643)
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1674)

___________________


Could I log the SQL statements or enable any other logging that might help?

Thanks & regards,
Tibi



Edited 1 time(s). Last edit at 07/06/2005 01:20PM by Tiberiu Fustos.