-
OS= Windoze NT
Oracle Ver= 8.1.6.1.0
Well, I have the error as you can see, here is the problem. We have 6 developement instances and only one is getting this error from the application code.
I checked the HASH_MULTIBLOCK_IO_COUNT for both integration test instances and they are at 0, so I can not set it any lower. The initial and next for the tablespace is 512K, yet in the other instance it is 20k and there is no problem there, strange.
Suggestions?
MH
ORA-03232 unable to allocate an extent of string blocks from tablespace string
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.
I remember when this place was cool.
-
Since this being the Rel 2 base, it could be the bug of not displaying the tablespace name. First get the tablespace name.
select name from sys.ts$ where ts# = ;
One other thing is make sure that your TEMP tablespace NEXT > HASH_MULTIBLOCK_IO_COUNT
The easiest of all is apply the patchset. If I remember correct 8.1.6 had been/ will be soon desupported.
Sam
Thanx
Sam
Life is a journey, not a destination!
-
Hi Hanky,
I got the same errror as yours. Can you tell me in detail your approach to get this stuff resolved. Any help from you is appreciated.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|