Re: Is there BCP like utility for Oracle (to unload data to text file)

On Wed, 3 Dec 1997 12:09:09 -0500, "Baolin ren" <baolin_at_imnet.com> wrote:

>SQLLoad
>
>Baolin
>
>Nuno Souto wrote in message <348516B9.7C8F_at_acay.com.au>...
>>Sergei Didur wrote:
>>>
>>> I know that SQL Loader could load data from text file, but
>>> I'd like to unload data from Oracle DB to text file.
>>> Is it possible ???
>>
>>
>>Use SQL*Plus with pagesize of 0 and spool the output.
>>

Another easy way to due this is to use an ODBC link to a Microsoft Access database. Then use the "get external data" function to link the tables. Then you can export to comma delimited or lotus or a bunch of other pc formats. Using Access works good if you are dealing with a small amount of data. It is slower than using sqlplus but it is very easy. Sqplus definitely work better if you are going to write a unix shell script to accomplish the entire task periodically.

• ========= ========= ========= ========= Noah Monsey noah_at_azlink.com
• ========= ========= ========= ========= The only dumb question is the one that you don't ask.
• ========= ========= ========= ========= Oracle Master Database Administration April 1992 Oracle Master Application Development April 1992
• ========= ========= ========= =========