migrating Mediumblob from mysql to oracle.

How to migrate mediumblob from mysql to oracle.Since the column contains more than 500MB of data it's diifcult to migrate.I'm using SQL*LOADER for migration.This is my CTL file

load data
infile 'AS_db.txt'
into table AS_DB
fields terminated by ','
trailing nullcols
(PACKAGE_PK integer,
ORDER_NUM integer,
"DATA" lobfile(constant "C:\omwb\sqlloader_scripts\MySQL3\13-12-2005_16-34-56\ Oracle\as_db.txt") terminated by EOF)
Here the problem is i have given the same file "AS_DB.txt" in both inifile section and lobfile section.

IS there anyother way it can be achieved.  

Thanks in Advance,
JAI Received on Tue Dec 13 2005 - 09:11:27 CST