Home > Cannot Close > Cannot Close Spool File

Cannot Close Spool File

If you know a good oracle reference/help site and think that site should be included in this search, you can contribute to this search engine here. Can anyone tell me what am I doing wrong. Leave a comment Post navigation Previous PostDynamic Performance Views(v$) Leave a Reply Cancel reply Enter your comment here... Thanks to everyone Comment Post Cancel fjleon Experienced Forum Member Join Date: Nov 2006 Posts: 282 #9 September 9th, 2010, 09:34 AM Re: Close printer file from another program Couldn't get this content

All rights reserved. ORA-00028 Permissions Required to Create a Materialized View... ► March (17) ► April (16) ► May (25) ► June (9) ► August (2) ► September (7) ► October (6) ► November Pgm1 does the actual printing. Thanks Comment Post Cancel jmp Experienced Forum Member Join Date: Mar 2009 Posts: 69 #6 September 8th, 2010, 07:47 PM Re: Close printer file from another program Hi, GLS400 solution is https://www.experts-exchange.com/questions/20850081/How-to-counter-an-error-SP2-0308-cannot-close-spool-file-while-spooling-a-file.html

So i guess i will try to detect in program B when i have no more data to print, and call A with the last record to print and just set Printed everything by calling program A, and after printing everything, i do a DLTOVR (*all) and then close PRT198. I need to do many sql queries to spool files *.dat(individually). 0 Question by:csganti Facebook Twitter LinkedIn Google LVL 23 Best Solution byseazodiac most likely the output from the spool is Large files option is enable, OS is 64 bit.

Remove advertisements Sponsored Links vbe View Public Profile Find all posts by vbe

« Previous Thread | Next Thread » Thread Tools Show Printable Version Email this Page Subscribe Our OS is 64 bit, but Sql*Plus looks like it uses 32 bit.... Simple template. Cust uses a datawarehouse database and usually need to create a file from sqlplus, using the spool option, with size greater than 2Gb..

I'm not anti-social, I just don't like people -Tommy Holden Comment Post Cancel JonBoy Analyst Join Date: Jun 2005 Posts: 422 #11 September 11th, 2010, 05:43 PM Re: Close printer file Oracle Database(Oracle DBA) Tuesday, 7 October 2014 SP2-0308: cannot close spool file SP2-0308: cannot close spool file This Error popup due to disk partition is going to full so to remove Pgm2 declares a print file and passes it as a parm to Pgm1. http://dbarahul.blogspot.com/2014/10/sp2-0308-cannot-close-spool-file.html All rights reserved.

Posted by Rahul Joshi at 04:21 Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest Labels: dba_errors, oracle 11g, Oracle error, SP2-0308: cannot close spool file No comments: Post a Comment Newer All times are GMT-6. Powered by Blogger. Below is from Oracles Support site...

Getting error: SP2 0308: cannot close spool file. http://dbaspot.com/oracle-errors/336178-sp2-0308-cannot-close-spool-file.html Join Now For immediate help use Live now! It stays open. Hits: 14743970 Books Terms & Conditions About Comments Facebook Sitemap Copyright © 2013 Login or Sign Up Log in with Facebook Search in titles only Search in RPG/RPGLE only Advanced Search

Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. news When Pgm2 is done printing it just closes the file - voila! Connect with top rated Experts 13 Experts available now in Live! I'm not anti-social, I just don't like people -Tommy Holden Comment Post Cancel GLS400 Analyst Join Date: May 2006 Posts: 2020 #4 September 8th, 2010, 03:59 PM Re: Close printer file

Printed everything by calling program A, and after printing everything, i do a DLTOVR (*all) and then close PRT198. 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 Pgm1 does the printing and returns. have a peek at these guys Join our community for more solutions or to ask questions.

For now i am using the extra parameter to set on LR at the end, but i am intrigued by the SHARE(*YES) one. thanks. I have a program (letīs call it A), that basically reads some data from files, and outputs it to a printer file (with O specs).

Close printer file from another program Collapse X Collapse Posts Latest Activity Search Page of 1 Filter Time All Time Today Last Week Last Month Show All Discussions only Photos only

LEARN MORE Join & Write a Comment Already a member? What is the point? Add Comment Your Comment Name: Comment: Captcha: Post Comment More Information The Google Search results shown above are obtained by searching for this error using a custom google search engine which Promoted by Experts Exchange Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

Forum Operations by The UNIX and Linux Forums Skip to content rahuljoshidba SP2-0308: cannot close spoolfile Posted on April 15, 2015 by rahuljsh1991 SP2-0308: cannot close spool file This Error Share this:TwitterFacebookGoogleLike this:Like Loading... Get 1:1 Help Now Advertise Here Enjoyed your answer? check my blog Tags: None GLS400 Analyst Join Date: May 2006 Posts: 2020 #2 September 8th, 2010, 03:56 PM Re: Close printer file from another program Hi fjleon: The easiest way is for program

Solved How to counter an error( SP2-0308: cannot close spool file ) while spooling a file Posted on 2004-01-13 Oracle Database 2 Verified Solutions 6 Comments 4,855 Views Last Modified: 2008-02-26 export can handle it even the dump file bigger than 2G bytes. 0 Featured Post Looking for New Ways to Advertise? Join and Comment By clicking you are agreeing to Experts Exchange's Terms of Use. Space was the problem.

I made up some free space and I was able to create the extracts. 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. MenuExperts Exchange Browse BackBrowse Topics Open Questions Open Projects Solutions Members Articles Videos Courses Contribute Products BackProducts Gigs Live Courses Vendor Services Groups Careers Store Headlines Website Testing Ask a Question Where is this file written?

Pgm2 calls Pgm1 to do the print. sponsored links Collapse Announcement Collapse No announcement yet. Seems you can't close files opened by other programs. Our system handles 2 Gig + files but we couldn't create a file > 2 gig....

error-code.org.uk Search FAQs Forum About SP2-0308cannot close spool file Version10.2.0 CauseThe file is currently being used.ActionRelease the file from the other process. First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone. Get super fast VPS hosting from just $5/mo! Privacy Policy Site Map Support Terms of Use Members Search Help Register Login Home Home» SQL & PL/SQL» SQL & PL/SQL» Spooling query to File give SP2-0308: cannot close spool file

Oracle Database Restoring a Database from User Managed Backups with Oracle Video by: Steve This video shows how to recover a database from a user managed backup Oracle Database Advertise Here The time now is 07:50 AM. - Contact Us - UNIX & Linux - unix commands, linux commands, linux server, linux ubuntu, shell script, linux distros. - Advertising - Top Join the community of 500,000 technology professionals and ask your questions. Program B has PRT198 declared as USROPN, and before opening it i did: OVRPRTF FILE(PRT198) TOFILE(*LIBL/PRT198) SHARE(*YES) Program A has prt198 declared without USROPN.