ORA-03232: 无法分配 34 块 (源于表空间 3)
刚帮同事解决了这个问题，记录一下。
ORA-03232: 无法分配 34 块 (源于表空间 3)
select * from v$tablespace where ts#=3
TEMP
解决方法：
alter tablespace temp default storage(next 1M);
资料：
摘自metalink 125271.1
Error: ORA-3232
Text: 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 the value of NEXT for the tablespace using ALTER TABLESPACE
DEFAULT STORAGE or decrease the value of HASH_MULTIBLOCK_IO_COUNT.
Option 1 -------- Set the initial and next extent size of the temporary tablespace equal to or greater than MAX_IO_SIZE.
Option 2 -------- Set HASH_MULTIBLOCK_IO_COUNT to a value different than 0. This however should not be required as Oracle computes the value individually for every query. If you let Oracle do the automatic computation, the value of the parameter appears as 0 in the V$PARAMETER dynamic performance view. Note: If you are using Oracle's multi-threaded server architecture, Oracle ignores any value you set for this parameter, and instead uses a value of 1
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/8102208/viewspace-591039/ ，如需转载，请注明出处，否则将追究法律责任。
