Message-ID: <39E2B56D.5EA711C2@globalone.ru>
Date: Tue, 10 Oct 2000 10:21:33 +0400
From: Alexander Medvedev <a.medvedev@globalone.ru>
Organization: Global One
X-Mailer: Mozilla 4.75 [en] (WinNT; U)
X-Accept-Language: ru,en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.misc
Subject: Re: Generic dump to text tool
References: <39E22A67.F0B0ED96@commserv.ucsb.edu>
Content-Type: text/plain; charset=koi8-r
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: 127.0.0.1
Lines: 26
NNTP-Posting-Host: news1.rosprint.net
X-Trace: 10 Oct 2000 10:16:01 +0400, news1.rosprint.net




Richard Allard wrote:

> I need a Windows NT command line utility that will dump an Oracle 7.3.2
> table to a
> tab delimited text file, with column headings included.  I would like to
> pass the
> utility owner, table name, where clause, order by, and output file name,
> and have
> it write the file.  I found DBMSCOPY, which works well interactively,
> but does not
> work in batch mode.  I am a programmer, and I do have M$ Visual Studio,
> so I could
> write something, but I'm not very experienced with the DAO/ODBC stuff.
>
> Does anyone have code examples or suggestions for products that will do
> this?
>
> TIA

Hi Richard, maybe it will be more easy to make a simple sql for what you
want script and run it  by sqlplus?

Regards Alexander