Re: Problems with Oracle to MySQL Migration

Hi Salvatore,

Salvatore Baglieri wrote:
> [snip]
>> 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
>> [snip]
> 1. I took the file classes102.zip from orant/java/lib folder.
> 2. I renamed it into ojdbc14.jar

Please check out the Online Forum http://forums.mysql.com/list.php?104 
where you will find more discussions about the MySQL Migration Toolkit.

What is your exact version of Oracle? Please note that only 8.1.5 and 
later are tested.

Which version of the Migration Toolkit are you using? Please make sure 
you have the latest one MT 1.1.9 installed. It is part of the GUI Tools 
for 5.0r9 bundle. Please download from

   http://dev.mysql.com/downloads/gui-tools/5.0.html

Using the old Oracle classes102.zip will not work. Using the original 
ojdbc14.jar is the way to go. The problem you are seeing is due to an 
not supported ALL_USERS Oracle view definition. This problem has been 
solved some time ago so I am wondering if you are using the latest 
version of the tool or your Oracle version is older than 8.1.5.

Please continue the discussion of the tool on the online forum which has 
more contributors than the mailing list and therefore is a better source 
of information.

Thanks!
Mike
-- 
Michael Zinner, GUI Developer
MySQL AB, www.mysql.com
Office: +43 676 593 08 23

Are you MySQL certified?  www.mysql.com/certification

-- 
MySQL GUI Tools Mailing List
For list archives: http://lists.mysql.com/gui-tools
To unsubscribe:    http://lists.mysql.com/[email protected]