ronald .. like mohan has identified .. u need 2 wakeup smon or use that fancy "alter session set events .." that scott or someone sent for forcing smon to start doing his stuff...
if you get the error even after coalescing then you might need to increae your temp tablespace deepak --- "Mohan, Ross" <[EMAIL PROTECTED]> wrote: > Let me guess that tablespace 3 is your temporary > tablespace? > > > > -----Original Message----- > Sent: Friday, October 19, 2001 12:00 PM > To: Multiple recipients of list ORACLE-L > > > > Hallo, > > what does this errormessage mean. I get it when i > try to do this select > statement. > If I dont include the last two lines in the > statement it works fine. What > does this depend on? and which action shallI do to > make it work? > > > SELECT RIK2.VARE.EAN_NR, > RIK2.VARE.LEVNR, > RIK2.ART_HIERARKI_CALC.VGR, > RIK2.VARE.SORTIMENT, > RIK2.VARE.VARENAVN > FROM RIK2.VARE, RIK2.ART_HIERARKI_CALC > WHERE RIK2.VARE.SELSKAP='11' AND > RIK2.VARE.VARE_SNR=10 > AND > RIK2.VARE.VARENR=RIK2.ART_HIERARKI_CALC.VARENR > ORDER BY VGR > > > ORA-03232: unable to allocate an extent of 62 blocks > from tablespace 3 > > > > > sincerely > > Roland Sköldblom > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California -- Public Internet > access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Mohan, Ross > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California -- Public Internet > access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __________________________________________________ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).