Paging in SPOOL Issue!
459628Dec 8 2006 — edited Dec 11 2006Hi,
I don't want to make any paging in the spool file but I am always getting a new page after ~65 lines, below my setting:
set verify off
set linesize 3000
set pagesize 6000000
set trimspool on
spool /m/home/omc/aa.txt
select * from KPI order by PST;
spool off
It's under HP-UNIX with Oracle 9i, is there any idea about this issue?
Notice that I did the same under my machine (Windows + Oracle 10g) and everything goes fine (no paging was in the output spool file)!
Thanks in advance