Re: Oracle exports to file, still unwanted lines

joostvanpoppel_at_gmail.com (joostvanpoppel) wrote in message news:<ca129b2f.0504052258.4c777cb8_at_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

set termout off echo off

Please note Oracle 8.0.3 was bugridden and withdrawn very quickly and desupport way before the current milennium.

--
Sybrand Bakker
Senior Oracle DBA