Re: Oracle 8i & DB2\UDB V7 Import data question ??

From: Dmitry Tolpeko <dmtolpeko_at_ispirer.com>
Date: Wed, 24 Jan 2001 16:03:40 GMT
Message-ID: <94mucj$97q$1@nnrp1.deja.com>

Hello.
You can use a database movement tool at www.ispirer.com/chyfo.html DB2 import command has many limitations for DEL format.

Chyfo exports data from DB2 (long datatypes are supported) to a text file, creates "create table" scripts Oracle and controls file for SQL Loader.
Chyfo has a lot of features.

Best regards, Dmitry.

In article <QTtb6.8711$65.50091_at_newsfeeds.bigpond.com>, "Techie" <webmaster_at_syncsoft.com.au> wrote:
> I've exported a DEL(normal comma delimited file) file from DB2\UDB
V7.1.
> Now I am trying to import into Oracle 8i. Problem is when importing
into
> Oracle, Oracle treats a carriage return as a delimiter for long data
types
> and fails to import. DB2 is fine. I am using SQLLoader. Is there a
way
> around this? I have a separate Control and data file.
> Ta much.
>
>

Sent via Deja.com
http://www.deja.com/ Received on Wed Jan 24 2001 - 10:03:40 CST