Re: Oracle 8.1.7 to MySQL: problem with SP and sequences
Posted by:
Cory Weston
Date: September 11, 2005 07:29PM
I am having a similar problem. Oracle 9i to mySQL
I know nothing about Oracle, except that I want to leave it behind. I need to get the tables and views out. I am hoping the views can be migrated into mySQL 5.
Using MT release 1.0.17 rc I had the error:
The schema could not be reverse engineered (error: 10008).
The function did not return an object.
I do not need to get sequences and stored procedures out and even took the, probably ill-advised, step of dropping all the sp's and seq's from the test copy of the Oracle database (this was not good for the views) I will be starting over with the complete Oracle database since the problem was not resolved by dropping the sp's and seq's anyway.
In the meantime I have I have tried release 1.0.18 rc
The error is now:
The schema could not be reverse engineered (error: 10008)
Here is what the log file (Java2Grt_com.mysql.grt.modules.BaseJava.java2GrtXmlLogging.xml) contains:
-
<data>
-
<value type="dict">
<value type="int" key="value">1</value>
</value>
</data>
The last part of the message log:
Fetch count of stored procedures of the schema GISOWN.
SELECT COUNT(*) AS NUM FROM ALL_PROCEDURES p WHERE p.OWNER=? ORDER BY p.OBJECT_NAME
Fetching 0 stored procedure(s) of the schema GISOWN.
SELECT p.*, (SELECT max(s.TYPE) FROM ALL_SOURCE s WHERE s.OWNER=? AND s.NAME=p.OBJECT_NAME) as TYPE FROM ALL_PROCEDURES p WHERE p.OWNER=? ORDER BY p.OBJECT_NAME
SELECT TEXT FROM ALL_SOURCE WHERE OWNER=? AND NAME=? ORDER BY LINE
Stored procedures fetched.
Fetch the number sequences of the schema GISOWN.
SELECT COUNT(*) AS NUM FROM ALL_SEQUENCES WHERE SEQUENCE_OWNER=?
Fetch 0 sequence(s) of the schema GISOWN.
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).
Thanks for your efforts. I suspect that there are lots of us wanting to make this migration.