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

JAI wrote:
> 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

DBMS_LOB built-in package.

www.psoug.org
click on Morgan's Library
click on DBMS_LOB
look at the demos at the bottom of the page
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)