Oracle 9i to MySQL 5.0.10 Problem with Sequences
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
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.