Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle exports to file, still unwanted lines
joostvanpoppel wrote:
> 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
Oracle 8.0.0.3? Are you working with some beta release in 8.0 track?
Anyways add these in the mix,
set echo off
set verify off
set trimspool on
Regards
/Rauf
Received on Wed Apr 06 2005 - 03:53:39 CDT