Re: Oracle export to ASCII file?
From: Chris Mac <chris_mac_at_my-deja.com>
Date: Mon, 13 Mar 2000 14:13:34 +0000
Message-ID: <38CCF78D.71B76F6_at_my-deja.com>
Date: Mon, 13 Mar 2000 14:13:34 +0000
Message-ID: <38CCF78D.71B76F6_at_my-deja.com>
Julio wrote:
> Sybrand Bakker wrote:
>
> > A database link would probably more appropiate but anyway.
> > The problem here most likely is the file needs to be ftp-ed or copied
> > BINARY, otherwise you will get problems with different CR/LF conventions on
> > NT and Linux.
>
> I've had no problems with exports from Digital to NT: The only thing you need is
> to transfer through ftp the file in BINARY mode, as Sybrand says. And depending
> on amount of tables, data in them, and so may be the import causes less
> problems.
>
You might find the default recordlength for exp/imp is different on NT and Unix, specify it on export and import to prevent problems... Received on Mon Mar 13 2000 - 15:13:34 CET