Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: migrating mysql to oracle database

Re: migrating mysql to oracle database

From: Uwe Schneider <uwe_at_richard-schneider.de>
Date: Sun, 18 Nov 2001 10:21:32 +0100
Message-ID: <3BF77D9C.A3672758@richard-schneider.de>


Sachin wrote:
>
> Hi there,
>
> I am trying to migrate from MySql database to oracle database using
> sqlloader. But the problem is one of my columns length is too big and
> oracle accepts only 255 characters per line command. So is there any
> way I can avoid that or is there anyway I can migrate or insert my
> data on MySQL to Oracle?

Why not just writing a tiny perl script based on DBI?

Uwe

-- 
Uwe Schneider       | Telefon +49 7244 / 609504
Karlsdorfer Str. 31 | Mail    uwe_at_richard-schneider.de
DE-76356 Weingarten | http://www.richard-schneider.de/uwe
Linux - OS al dente!
Received on Sun Nov 18 2001 - 03:21:32 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US