Oracle exports to file, still unwanted lines

From: joostvanpoppel <joostvanpoppel_at_gmail.com>
Date: 5 Apr 2005 23:58:49 -0700
Message-ID: <ca129b2f.0504052258.4c777cb8@posting.google.com>

Hi,

Im working with Oracle 8.0.0.3. and want to export the content of a table to a file.

I do this using the following:
Set linesize 250
Set feedback off
Set heading off
Spool c:\deb_exp.txt
SELECT * FORM deb_export_converted;
Spool off
Set feedback on
Set heading on

The content of the exported file looks like this: SQL> SELECT * FROM deb_export_omgezet;

7000;LH;Louis;1;3 
7001;TH;Theo;1;3 
7002;SJ;Sjaak;1;3 
7003;NR;Nico;1;3 
7004;MH;Martin;1;3 
7005;JP;Joost;1;3 
7006;GR;Gerard;1;3 
7007;FA;Fahrad;1;3 
7008;EB;Epi;1;3 
7009;RE;RE;1;3 
7010;TP;Tom;1;3 

SQL> SPOOL OFF I donīt want oracle to export the lines:
- SQL> SELECT * FROM deb_export_omgezet;

• SQL> SPOOL OFF

Does anyone know how to solve this?

Thanks in advance,

Joost van Poppel Received on Wed Apr 06 2005 - 01:58:49 CDT