Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
ORA-03232: unable to allocate an extent (Read 4663 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
ORA-03232: unable to allocate an extent
16.02.07 at 13:58:30
 
ORA-03232: unable to allocate an extent of n blocks from tablespace x
 
When executing a join query I received this error message:
ORA-03232: unable to allocate an extent of 55 blocks from tablespace 4
 
How to figure out which tablespace number 4 is?
In v$tablespaces you can lookup the tablespace number.:
 

select * from v$tablespace
order by TS#
      TS# NAME                        
---------- ------------------------------
      0 SYSTEM                        
      1 RBS                          
      3 USERS                          
      4 TEMP  

 
 


Problem was fixed by setting HASH_MULTIBLOCK_IO_COUNT  to 1 (was 0).
Back to top
 
« Last Edit: 20.02.07 at 08:03:48 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1