MySQL, Clearing source model and ORA-00942
453582Oct 7 2005 — edited Dec 11 2008Hello! 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!