OraFAQ Forum: SQL & PL/SQL » Spooling query to File give SP2-0308: cannot close spool file

Home » SQL & PL/SQL » SQL & PL/SQL » Spooling query to File give SP2-0308: cannot close spool file

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Spooling query to File give SP2-0308: cannot close spool file [message #5262]

Thu, 06 February 2003 11:47

Jaganmohan
Messages: 3
Registered: February 2003

Junior Member

Hi,

I executed the script below and I get an error message SP2-0308: cannot close spool file. Can anyone tell me what am I doing wrong.

set pagesize 0
set head off
set linesize 100
set feedback off

set colsep ''

spool FILE1.dat

select cluster_cd,cluster_desc,setid,eff_start_dt,eff_end_dt,active_fg,start_dt,end_date from v_tmp_cluster;

spool off

Thanks for your help.

Jagan

Report message to a moderator

Re: Spooling query to File give SP2-0308: cannot close spool file [message #5264 is a reply to message #5262]

Thu, 06 February 2003 11:51

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

look for the available disk space
or try to spool in someother location.

spool d:somedirFILE1.dat

select cluster_cd,cluster_desc,setid,eff_start_dt,eff_end_dt,active_fg,start_dt,end_date from v_tmp_cluster;

spool off

Report message to a moderator

Re: Spooling query to File give SP2-0308: cannot close spool file [message #5271 is a reply to message #5264]

Thu, 06 February 2003 14:14

Jaganmohan
Messages: 3
Registered: February 2003

Junior Member

Mahesh,
You hit the bulls eye. Space was the problem. I made up some free space and I was able to create the extracts.

thanks.
Jagan

Report message to a moderator

Previous Topic:	cannot aquire LOCK on a TABLE
Next Topic:	query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 17 20:29:50 CDT 2024