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" <MohanR_at_STARS-SMI.com> 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: Roland.Skoldblom_at_ica.se
>
> 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: ListGuru_at_fatcity.com (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: MohanR_at_STARS-SMI.com
>
> 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: ListGuru_at_fatcity.com (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: deepakthapliyal_at_yahoo.com
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: ListGuru_at_fatcity.com (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).
Received on Fri Oct 19 2001 - 12:24:18 CDT
