Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Generic dump to text tool
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