Hi,
I get the following error during reverse engineering while trying to migrate from Oracle to MySQL:
------------------------------------------
[...]
Views fetched.
Fetch count of stored procedures of the schema CHRIS.
SELECT COUNT(*) AS NUM FROM ALL_PROCEDURES p WHERE p.OWNER=? ORDER BY p.OBJECT_NAME
Stored procedures cannot be fetched.
ORA-00942: table or view does not exist
Fetch the number sequences of the schema CHRIS.
SELECT COUNT(*) AS NUM FROM ALL_SEQUENCES WHERE SEQUENCE_OWNER=?
Fetch 113 sequence(s) of the schema CHRIS.
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.
------------------------------------------
My setup looks like this:
- Oracle 8i Enterprise Edition Release 8.1.7.0.1 (remote, Linux)
- MySQL 4.1.13a-nt (local, Windows XP)
- MySQL Migration Toolkit 1.0.12rc (local)
- ojdbc14.jar JDBC driver from the Oracle website
Of course, the tool works perfectly well with empty schemata.
The problem is possibly related to
http://forums.mysql.com/read.php?104,32673
Any ideas what could be the issue?
Is it a bug or maybe all my fault?
Greets,
Philip
Edited 1 time(s). Last edit at 08/11/2005 08:56AM by Philip Busch.