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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Oracle 8i & DB2\UDB V7 Import data question ??

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

From: Techie <webmaster_at_syncsoft.com.au>
Date: Thu, 25 Jan 2001 17:36:17 +1000
Message-ID: <vLPb6.9356$65.54070@newsfeeds.bigpond.com>

Thanks,

I'll give it a go.

Regards,
Techie.

Dmitry Tolpeko wrote in message <94mucj$97q$1_at_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 Thu Jan 25 2001 - 01:36:17 CST

Original text of this message

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