Roland,
Your qry is making a HASH join and eating up the temp tablespace. The solution is to
increase the parameter HASH_MULTIBLOCK_IO_COUNT in init.ora and bounce the db once. By
default this parameter is '0'. So increase the next extent parameter for the temp
tablespace.
alter tablespace tem
When tablespace 3 is your temp tablespace
Look into possibility of extending that one eg:
autoextend, add another datafile
Hth,
Jeroen
>-Oorspronkelijk bericht-
>Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>Verzonden: dinsdag 23 oktober 2001 10:10
>Aan: Multiple recipients of lis
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.
[EMAIL PROTECTED] wrote:
Hallo
I run this select statement and get this errormessage. What should I do to
Seek and ye shall find
oracle@tyne:/usr/oracle >oerr ora 3232
03232, 0, "unable to allocate an extent of %s blocks from tablespace %s"
// *Cause: An attempt was made to specify a HASH_MULTIBLOCK_IO_COUNT value
// that is greater than the tablespace's NEXT value
// *Action: Increase
Title: RE: Errormessage
see answer below
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>
> 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 statemen
It means you need to allocate more space to Tablespace 3. You can either
increase the size of the current datafile(s) or add another datafile.
Regards.,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, October 19, 2001 12:00 PM
H
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, R
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
