tool kit - Oracle to MySQL
Hi, I'm new to MySQL and trying to migrate small oracle schema with close to 350 tables to MySQL. Migration toolkit is not working for me. It is struck after a 3 rd step all the time. It alos took close to 60Mins to complete fetching column information and never moved after Fetch PK.. See the msg log after masking some critical info.. Any help to resolve this issue would be nice
Initializing JDBC driver ...
Driver class Oracle Thin JDBC Driver using SID
Build simple Oracle datatypes.
Call Oracle stored procedure ANALYZE_SCHEMA for ???
CALL DBMS_UTILITY.ANALYZE_SCHEMA(?, 'ESTIMATE', 50, 0, 'FOR TABLE')
Fetch the number of tables in the schema ??
SELECT COUNT(*) AS TABLECOUNT FROM ALL_TABLES t, ALL_OBJECTS a WHERE t.OWNER=? AND a.OWNER=t.OWNER AND a.OBJECT_NAME=t.TABLE_NAME AND a.OBJECT_TYPE='TABLE' AND a.STATUS='VALID'
Fetching ??? table(s) of the schema ????
SELECT t.* FROM ALL_TABLES t, ALL_OBJECTS a WHERE t.OWNER=? AND a.OWNER=t.OWNER AND a.OBJECT_NAME=t.TABLE_NAME AND a.OBJECT_TYPE='TABLE' AND a.STATUS='VALID' ORDER BY t.OWNER, t.TABLE_NAME
Fetch column information.
Fetching column information.
SELECT tc.TABLE_NAME, tc.COLUMN_NAME, tc.DATA_TYPE, tc.DATA_TYPE_MOD, tc.CHAR_LENGTH, tc.DATA_LENGTH, tc.DATA_PRECISION, tc.DATA_SCALE, tc.NULLABLE, tc.DEFAULT_LENGTH, tc.DENSITY, tc.NUM_NULLS, tc.NUM_BUCKETS, tc.CHARACTER_SET_NAME, tc.DATA_DEFAULT FROM ALL_TAB_COLUMNS tc, ALL_TABLES t WHERE tc.OWNER=? AND t.OWNER=tc.OWNER AND tc.TABLE_NAME=t.TABLE_NAME ORDER BY tc.TABLE_NAME, tc.COLUMN_ID
Fetch PK information.
Edited 1 time(s). Last edit at 08/16/2007 03:52AM by Baskar Ramamoorthy.