Re: Delimited Output

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Mon, 11 Oct 1999 12:06:18 -0400
Message-ID: <0woCOMnG+14roY1OK7qTmdqqOTcd@4ax.com>

A copy of this was sent to Rex Bigger <"rex.bigger<REMOVE>"@capitalradio.co.uk> (if that email address didn't require changing) On Mon, 11 Oct 1999 15:43:45 +0100, you wrote:

>Hi,
>
>I'm a relative Oracle newbie and I need to out put the entire
>contents of a table (some 200,000 records) into a delimited
>ASCII text file.
>
>I'm using Oracle 7 on Solaris..
>
>How do I do it, I've looked through all the docs I have and can't
>find anyway of doing this.
>
>rex..

goto to the URL in my signate and see

Unloader - unload data from Oracle into a flat file or into a file suitable for sqlldr to reload

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Oct 11 1999 - 11:06:18 CDT