troubles migrating tables from oracle 8.1.5
Posted by: David Pfeiffer
Date: September 20, 2005 10:53AM

Hi,

I tried to migrate from Oracle8i using the mysql-migration-toolkit-1.0.18-rc.

The Reverse Engineering job ends with the following Message Log



Fetch count of stored procedures of the schema TRAVELMANAGER.
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 TRAVELMANAGER.
SELECT COUNT(*) AS NUM FROM ALL_SEQUENCES WHERE SEQUENCE_OWNER=?
Fetch 0 sequence(s) of the schema TRAVELMANAGER.
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.
Could not parse XML data

Its a rather complicated relational model. I tried the migration tool with other less complicated models and it worked. Does anybody know the reason for this error?

Options: ReplyQuote


Subject
Written By
Posted
troubles migrating tables from oracle 8.1.5
September 20, 2005 10:53AM


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.