Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Generic dump to text tool

Re: Generic dump to text tool

From: Alexander Medvedev <a.medvedev_at_globalone.ru>
Date: Tue, 10 Oct 2000 10:21:33 +0400
Message-ID: <39E2B56D.5EA711C2@globalone.ru>

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 Received on Tue Oct 10 2000 - 01:21:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US