SQLPlus spool file

Leo_NN · #1 (**permalink**) 11-20-2008

HI

Have some problem with spooling out some relatively large number of records (~2-3 mil)
Small table - OK though.

Getting error: SP2 0308: cannot close spool file.

Any thoughts?

Code:

sqlplus -s user/pwd << EOF 
  set term off
  set head off
  set trims on
  set pages 0
  set feedback off
  set linesize 1000
 
 
      spool test.dat
            select * from small_table; -- OK
            --select * from large_table;  --ERROR
      spool off
  exit 0;
EOF

vbe · #2 (**permalink**) 11-21-2008

Have you just an idea of the size of the file?...
What is the point?
You will have quite some trouble looking at it with vi...
Where is this file written? do you have to be safe >3GB free there?

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
grep spool file error	ran16	Shell Programming and Scripting	12	06-18-2008 01:31 PM
how to spool a unix file	kripssmart	Shell Programming and Scripting	2	06-18-2008 04:35 AM
Can I delete the file var/spool/mail/news?	dennisheazle	UNIX for Dummies Questions & Answers	3	04-08-2008 11:12 PM
code to FTP the spool file from Sqlplus to the unix server.	vprevin	Shell Programming and Scripting	0	10-31-2007 02:48 AM
Increase width of Spool file	handynas	UNIX for Dummies Questions & Answers	2	11-20-2001 09:24 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: