Re: Data Dump

On Mon, 17 Nov 1997 17:34:24 -0600, Ed Gillispie <eg76440_at_deere.com> wrote:

>Does any one have a script that will dump the data from a selected
>Oracle table (preferably in the order of the primary key) to an ASCII
>text file for loading to a mainframe?
>
>Your help is greatly appreciated!

 Why not simply perform a select on the table, using an 'order by' clause and and write the output to OS file?

Remebering to switch of erroneous SQL outputs, such as column headings, first e.g.

sqlplus scott/tiger <sql.in >sql.output

sql.in, in this case might contain something like:

set heading off;
set termout off;
set feedback off;
select * from mytable
order by thiscolumn;

Good luck,
Mark Received on Tue Nov 18 1997 - 00:00:00 CST