Printable View
Alright lads,
I have a user getting an ora-03233 error.
I checked this on OTN and the error means that is unable to allocate an extent of string blocks from tablespace string.
Can anyone expand on this?
Also to fix it, it says to increase the value of NEXT for the tablespace, or decrease the value of HASH_MULTIBLOCK_IO_COUNT. Is this all I have to do? What problems shoud I expect?
Were running 8.1.6 on Solaris.
Cheers
Dougie
Oracle Corporation does not recommend that you set or change the value of this parameter.
http://technet.oracle.com/docs/produ...ch158.htm#3004
Are you sure of the error number.
For ORA-03233 it says:
ORA-03233 unable to extend table string.string subpartition string by string in tablespace string
Cause: Failed to allocate an extent for table subpartition segment in tablespace.
Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.
HTH
tycho