Re: Migrating to MySQL 5

[Michael G. Zinner]

Which version of Oracle are you using? Currently we are testing a gainst 9.2i and 10g. As which user are you connecting?

Could you try to run the select from below in SQL Plus and use a SHOW ERROR; to see what the exact problem is?

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

Could you also check if this select returns all columns listed in the 9.2 documentation for ALL_VIEWS?

A link to the documentation is on http://www.lc.leidenuniv.nl/awcourse/oracle/server.920/a96536/ch2159.htm#1164332

You feedback would be much appreciated.

I will replace the SELECT v.* with the actual columns because this will give a better error message in the tool.

Thanks,
Mike