This discussion is archived
1 Reply Latest reply: Nov 10, 2011 10:26 PM by kgronau RSS

Mysql to Oracle Offline Migration: scripts incorrectly generated for tables

862596 Newbie
Currently Being Moderated
Hi,

I used SQL Developer 3.0.4 to migrate Mysql databases to Oracle.

I got the following errors on execution of the loader scripts (oracle_ctl.sh):

SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.
SQL*Loader-500: Unable to open file (data/framework_perdadepacotes_diari.txt)


The dump file "framework_perdadepacotes_horario.txt" is generated by mysqlsdump with the original mysql table name and ".txt" sufix:
-- extracted from unload_script.sh
mysqldump -h $server -u $username -p$password -T data socket=/u01/mysqlmulti/mysql2/mysqld2.sock port=3312 fields-terminated-by="<EOFD>" fields-escaped-by="" --lines-terminated-by="<EORD>" "dxdb" "framework_perdadepacotes_horario"

but the sql loader controlfile references the file using the new oracle table name (in this case the new name is truncated to 30 characters):
--
load data
infile 'data/framework_perdadepacotes_diari.txt'
"str '<EORD>'"
into table dxdb.framework_perdadepacotes_diari


Another occurrence of the same problem, but in this case the tables names starts wth "_" :
- from unload_script.sh
mysqldump -h $server -u $username -p$password -T data fields-terminated-by="<EOFD>" fields-escaped-by="" --lines-terminated-by="<EORD>" "netdb" "_Clientes"

file name generated by mysqldump: "_Clientes.txt"
ctl file:
load data
infile 'data/CLIENTES_1.txt'
"str '<EORD>'"
into table CLIENTES_1

Is this a bug or are we supposed to manually correct the scripts for these cases?

Thanks

Edited by: user12099785 on 10/11/2011 06:11

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points