Migrate from Oracle 10g - "Bigger type length than Maximum"

[Dave Whitla]

I am running the Windoze GUI Migration Tool (in wine) on my debian linux box, attempting to migrate an Oracle 10g database currently hosted on a RatHead EL3 box.

The "Reverse Engineering" step fails while trying to ANALYZE_SCHEMA as follows:

Initializing JDBC driver ...
Driver class Oracle Thin JDBC Driver using SID
Opening connection ...
Connection jdbc:oracle:thin:dwhitla/jaguar01@devoracle:1521:jaguar
Initializing JDBC driver ...
Driver class Oracle Thin JDBC Driver using SID
Opening connection ...
Connection jdbc:oracle:thin:dwhitla/jaguar01@devoracle:1521:jaguar
Getting version information ...
Build simple Oracle datatypes.
Call Oracle stored procedure ANALYZE_SCHEMA for DWHITLA.
CALL DBMS_UTILITY.ANALYZE_SCHEMA(?, 'ESTIMATE', 50, 0, 'FOR TABLE')
The schema could not be reverse engineered (error: 0).
ReverseEngineeringOracle.reverseEngineer :Bigger type length than Maximum
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.T4C8TTIrxh.unmarshalV10(T4C8TTIrxh.java:98)
oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:495)
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)
oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:543)
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1028)
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2888)
oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:2979)
com.mysql.grt.modules.ReverseEngineeringOracle.reverseEngineer(Unknown Source)
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)


I have tried migrating other schemas on the same Oracle server to see if there was something peculiar about this schema, with the same result. I'm guessing there is some problem in converting a BLOB type column. Unfortunately I have no idea how to find any more debugging info.

Any ideas would be appreciated.
In the meantime I will try the linux CLI script.