Re: Oracle 8.1.7 to MySQL still has issues with Views
Posted by: Michael G. Zinner
Date: July 05, 2005 11:52AM

Could you check if this is a privilege issue? The views ALL_VIEWS and ALL_CONSTRAINTS need to be accessable.

Did I ask you to execute the select in SQL*Plus already? Does it work there?

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

Thanks,
Mike

Michael Zinner, Team Lead, Developer Tools
MySQL AB, www.mysql.com

Are you MySQL certified? www.mysql.com/certification

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.