Re: migrating mysql to oracle database

From: Geoff Reader <grr_at_NOSPAM.bton.ac.uk>
Date: Mon, 19 Nov 2001 16:23:58 +0000
Message-ID: <3BF9321E.C4FCFBA8@NOSPAM.bton.ac.uk>

Look at the UTL_FILE utility, it allows up to 1022 chars natively, and someone recently mentioned you could increase that by overloading it with max_linesize.

Good luck

Geoff
Analyst Programmer
ACS
University of Brighton

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?
Received on Mon Nov 19 2001 - 10:23:58 CST