From mandar_shete@indiatimes.com Tue, 23 Oct 2001 01:11:36 -0700 From: "Mandar Shete" Date: Tue, 23 Oct 2001 01:11:36 -0700 Subject: Re: Errormessage Message-ID: MIME-Version: 1.0 Content-Type: text/plain Hi Roland, check if your temp tablespace is getting filled up (look at dba_free_space, v$sort_segment, v$sort_usage). Are you getting any other messages with this one ? Mandar. ORACLE-L@fatcity.com wrote: Hallo I run this select statement and get this errormessage. What should I do to solve it? I have a databaselink from the actual schema to another schema. 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 Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Roland.Skoldblom@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@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). Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com Buy Music, Video, CD-ROM, Audio-Books and Music Accessories from http://www.planetm.co.in --=_MAILER_ATTACH_BOUNDARY1_2001102321319121061730690 Content-Type: text/html; charset=us-ascii

Hi Roland, check if your temp tablespace is getting filled up (look at dba_free_space, v$sort_segment, v$sort_usage). Are you getting any other messages with this one ?

Mandar.



ORACLE-L@fatcity.com wrote:


Hallo





I run this select statement and get this errormessage. What should I do to solve it? I have a databaselink from the actual schema to another schema.





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


Thanks in advance





Roland

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: Roland.Skoldblom@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@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).

Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com
Buy Music, Video, CD-ROM, Audio-Books and Music Accessories from http://www.planetm.co.in --=_MAILER_ATTACH_BOUNDARY1_2001102321319121061730690-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar Shete INET: mandar_shete@indiatimes.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@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).