Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: migrating Mediumblob from mysql to oracle.
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_at_x.washington.edu (replace x with u to respond)Received on Tue Dec 13 2005 - 12:38:03 CST