Re: Unload

From: <denny_vk_at_hotmail.com>
Date: 1998/02/27
Message-ID: <6d6ccq$48t$1@nnrp1.dejanews.com>#1/1

Hi,

I am not sure whether this works with Oracle 6 as I don't have access to one, but with 7.x and above you can try setting the LINESIZE in sqlplus. Give

set linesize <n> ( Where n is a number greater than the row length )

You can also set pagesize to 0 so that there will not be any blank lines in between.

Hope this works.

Denny

In article <34F427FB.C2457737_at_cdsi.com>, Yiu Shih Lee <yiu_shih_lee_at_cdsi.com> wrote:
>
> Is it possible to unload the data in a table to a flat file in Oracle6
> for future load with sqlloader? I have tried with select statement, but
> it limit to 80 characters. My purpose is to archive the older data.
> Thanks in Advance.
>
> Yiu Shih
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri Feb 27 1998 - 00:00:00 CST