I want to export data from Oracle to a text file. Since Oracle doesn't have
export/import utility, which is sad (it has, but only from/to Oracle - dump
files), I am using SQLPlus to spool query output to a file.
Is there a way to exclude query text at the begining and prompt at the end
of the output file? I just want the data, no headers etc.
I set all parameters to OFF, but it didn't help.
Also, what 3rd party software would you recommend for export/import,
something similar to SQL Server's DTS, with all formats (text, dBASE,
Access, etc etc)?
Best regards.
Received on Thu Nov 25 1999 - 09:02:03 CST
