Problems with Oracle to MySQL Migration

"Salvatore Baglieri" <[email protected]> Wed, 31 Jan 2007 10:09:53 +0100
Newsgroups gmane.comp.db.mysql.mycc
Message-ID <[email protected]>
Hi all, this is my first email.

I'm trying to migrate from Oracle to MySql using the Migration Toolkit (that
works with MS SQL Server and Access as source).

But it doesn't work.

1. Direct Migration
2. Oracle Database Server - Thin JDBC Driver using SID
3. MySQL Server - 127.0.0.1 and so on...
4. Connecting to source database system (it's Oracle8)

Connecting to source database and retrieve schemata names.
Initializing JDBC driver ...
Driver class Oracle Thin JDBC Driver using SID
Opening connection ...
Connection jdbc:oracle:thin:username/[email protected]:1521:fid1
Fetching schemata list.
SELECT USERNAME FROM ALL_USERS ORDER BY USERNAME
The list of schema names could not be retrieved (error: 0).
ReverseEngineeringOracle.getSchemata :La lunghezza del tipo รจ superiore al
valore massimo
Details:
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
oracle.jdbc.driver.DatabaseError.check_error(DatabaseError.java:885)
oracle.jdbc.driver.T4CMAREngine.buffer2Value(T4CMAREngine.java:2231)
oracle.jdbc.driver.T4CMAREngine.unmarshalUB2(T4CMAREngine.java:1048)
oracle.jdbc.driver.T4CTTIdcb.receiveCommon(T4CTTIdcb.java:112)
oracle.jdbc.driver.T4CTTIdcb.receive(T4CTTIdcb.java:95)
oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:591)
oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112)
oracle.jdbc.driver.T4CStatement.execute_for_describe(T4CStatement.java:351)
oracle.jdbc.driver.OracleStatement.execute_maybe_describe(
OracleStatement.java:896)
oracle.jdbc.driver.T4CStatement.execute_maybe_describe(T4CStatement.java
:383)
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
:986)
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1125)
com.mysql.grt.modules.ReverseEngineeringOracle.getSchemata(
ReverseEngineeringOracle.java:52)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
com.mysql.grt.Grt.callModuleFunction(Unknown Source)

What's the matter?

Is there another free tool to migrate from Oracle to MySQL?

Is there a free tool to obtain SQL statements from a Select on Oracle?

Is there a free tool to convert dmp files to SQL Statements or to import dmp
file into MySQL?

Thanks in advance

---
Ing. Salvatore Baglieri