Oracle 9i to MySQL 5.0.10 Problem with Sequences
Posted by: chandra sekhar
Date: July 30, 2005 04:16AM

Source Database Oracle 9.2.0.5
Target Database MySQL 5.0.10
Migration toolkit 1.0.11

After the query
SELECT SEQUENCE_NAME, MIN_VALUE, MAX_VALUE, INCREMENT_BY, CYCLE_FLAG, ORDER_FLAG, CACHE_SIZE, LAST_NUMBER FROM ALL_SEQUENCES WHERE SEQUENCE_OWNER=?
The schema could not be reverse engineered (error: 10008).
The function did not return an object.

Unable to migrate sequences, the tool exits with error: 10008

I am connecting as the sys user, same query with the same user runs fine on SQL plus

Any ideas why it is failing???

Thanks in Advance
Chandra

Options: ReplyQuote


Subject
Written By
Posted
Oracle 9i to MySQL 5.0.10 Problem with Sequences
July 30, 2005 04:16AM


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.