Re: Oracle 8.1.7 to MySQL still has issues with Views
Posted by: Tiberiu Fustos
Date: July 10, 2005 03:19AM

Hi Mike,

I tried with the new version. It still does not work. I tried both with a schema with views, as well as with one without views in it - I always got the same error.

Then I tried a trace on the entire DB - and here is what I've found - it looks like it's not the ALL_VIEWS statement causing the problem, but the following:
____________

The following statement encountered a error during parse:

SELECT COUNT(*) AS NUM FROM ALL_PROCEDURES p WHERE p.OWNER=:1 ORDER BY p.OBJECT_NAME

Error encountered: ORA-00942
********************************************************************************

Unfortunatelly ALL_PROCEDURES is not a view available for Oracle 8, only from 9 onwards.
Since the stored procedures are anyway not migrated, would it be possible to exclude this call and let the rest of the objects get migrated?

-> I found a discussion on this topic here:
http://www.thetechtwo.com/detail-10118748.html


Thanks & Regards,
Tibi



Edited 3 time(s). Last edit at 07/10/2005 04:42AM by Tiberiu Fustos.

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.