MySQL Forums
Forum List  »  Oracle

Re: Importing from Oracle into MySQL
Posted by: Salvatore Baglieri
Date: February 03, 2007 01:36AM

David Beckedorff Wrote:
-------------------------------------------------------
> Circling back to the MySQL Migration Toolkit ...
>
>
> Does anyone know why I'm getting this error after
> specifying the source Oracle database and the
> target MySQL database and clicking 'Next'?
>
> >>>
> Connecting to source database and retrieve
> schemata names.
>
> The list of schema names could not be retrieved
> (error: 0).
> oracle.jdbc.OracleDriver
>
> Details:
> java.net.URLClassLoader$1.run(Unknown Source)
> java.security.AccessController.doPrivileged(Native
> Method)
> java.net.URLClassLoader.findClass(Unknown Source)
> java.lang.ClassLoader.loadClass(Unknown Source)
> sun.misc.Launcher$AppClassLoader.loadClass(Unknown
> Source)
> java.lang.ClassLoader.loadClass(Unknown Source)
> java.lang.ClassLoader.loadClassInternal(Unknown
> Source)
> java.lang.Class.forName0(Native Method)
> java.lang.Class.forName(Unknown Source)
> com.mysql.grt.modules.ReverseEngineeringOracle.get
> Schemata(Unknown Source)
> sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ
> e Method)
> sun.reflect.NativeMethodAccessorImpl.invoke(Unknow
> n Source)
> sun.reflect.DelegatingMethodAccessorImpl.invoke(Un
> known Source)
> java.lang.reflect.Method.invoke(Unknown Source)
> com.mysql.grt.Grt.callModuleFunction(Unknown
> Source)
> <<<
>
>
> The Oracle user login I'm using has been granted
> 'dba' privileges temporarily.
>
>
> -David


On 2/2/07, Michael G. Zinner <mzinner@NO_SPAM.com> wrote:

The problem is that Oracle has changed the system VIEWs between the
versions. That means we have to add support for each X.Y version.

I could fix the initial retrieval of the SCHEMA information but I think
we would run into similar problems with the TABLE information.


Have you tried the tools from http://www.swissql.com/ ? I have heard
good things about them.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Importing from Oracle into MySQL
4017
February 03, 2007 01:36AM
3982
January 22, 2007 12:48AM
4609
March 30, 2005 06:13PM


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.