Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

MySQL, Clearing source model and ORA-00942

453582Oct 7 2005 — edited Dec 11 2008
Hello! I am currently trying to configure Migration Workbench to work with a MySQL 4.x database. I have been through all the threads and followed all of the recommendations found. I have created, dropped, recreated repository users. I have created new repository in it's own very large tablespace. I have tried many different versions of the mysql driver. I am able to get through the 4 steps of the wizard to capture the data source, and then receive the above error. Here is an extract from my Error.log file:

** Oracle Migration Workbench
** Production
** ( Build 20050629 )

** OMWB_HOME: /opt/oracle/admin/oradev/downloads/omwb

** user language: en
** user region: null
** user timezone:
** file encoding: UTF-8
** java version: 1.4.2_08
** java vendor: Sun Microsystems Inc.
** o.s. arch: i386
** o.s. name: Linux
** o.s. version: 2.6.11.4-20a-bigsmp

** Classpath:

../lib/boot.jar


** Started : Fri Oct 07 09:54:45 EDT 2005

** Workbench Repository : Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

Repository Connection URL: jdbc:oracle:thin:@odb2:1521:oradev

** The following plugins are installed:

** MySQL 4.X Plugin, Production Release 10.1.0.4.0

** Active Plugin : MySQL4

Any help would be greatly appreciated!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 8 2009
Added on Oct 7 2005
17 comments
7,183 views