Re: Oracle 8.1.7 to MySQL still has issues with Views

[David Fury]

I'm also trying to reverse engineer an 8.1.7 database.
I got round the 'ALL_PROCEDURES' hiccup by defining a simple view against all_objects. It then got as far as a message saying 'sequences fetched' and then failed with the following:

-----------------------------

SELECT COUNT(*) AS NUM FROM ALL_SEQUENCES WHERE SEQUENCE_OWNER=?
Fetch 5 sequence(s) of the schema BTRAK.
SELECT SEQUENCE_NAME, MIN_VALUE, MAX_VALUE, INCREMENT_BY, CYCLE_FLAG, ORDER_FLAG, CACHE_SIZE, LAST_NUMBER FROM ALL_SEQUENCES WHERE SEQUENCE_OWNER=?
Sequences fetched.
The schema could not be reverse engineered (error: 0).
The function did not return an object.

-------------------------------

Which part of the catalog is it now trying to query? Any info gratefully received