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.