Click here to Skip to main content
15,880,967 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
I'm a beginner to oracle..
I'm getting error while creating spool file in oracle 10g..
error is:
SP2-0768:Illegal spool command....
Posted
Comments
CHill60 29-Jul-14 12:55pm    
Are you running on Windows or Unix?

1 solution

its the procedure to create the spool file
1 : open your sqlprompt
its look like
sql>
2 : Go to file at the left side at the top
3: left click on file there spool will be there
4: then click on spool it will show 2icon
1> spool files,2> spool of
click on spool files then set the location of spool file and save it
5:if every thing ok then in sql prompt write
sql> spool on
and press enter
simply it work and to off the spool write
sql> spool off
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900