Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Paging in SPOOL Issue!

459628Dec 8 2006 — edited Dec 11 2006
Hi,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 8 2007
Added on Dec 8 2006
9 comments
1,389 views