From: noah@azlink.com (Noah Monsey) Subject: Re: Is there BCP like utility for Oracle (to unload data to text file) Date: 1997/12/04 Message-ID: <34873382.24121433@207.225.159.3>#1/1 References: <01bcfe96$6de8bcd0$79a06080@sdidur-1> <348516B9.7C8F@acay.com.au> <66449o$jq7$1@viper.america.net> Newsgroups: comp.databases.oracle,comp.databases.oracle.misc,comp.databases.oracle.server On Wed, 3 Dec 1997 12:09:09 -0500, "Baolin ren" wrote: >SQLLoad > >Baolin > >Nuno Souto wrote in message <348516B9.7C8F@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@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 ========= ========= ========= ========= =========