-
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.
[url]http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76961/ch158.htm#3004[/url]
-
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
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
|