Re: Unload

From: jojo <jojo_at_nowhere.com>
Date: 1998/02/27
Message-ID: <34F71455.2475@nowhere.com>#1/1

This works for version 6 too.

denny_vk_at_hotmail.com wrote:
>
> 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