, 2002 9:08 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: MAX_IO_SIZE and Temp Next Extent approach to ORA-03232
Error
When i had this problem i put initial and next extent size of temporary
tablespace
equal or greater than MAX_IO_SIZE.
Example: With MAX_IO_SIZE= 128K
When i had this problem i put initial and next extent size of temporary
tablespace
equal or greater than MAX_IO_SIZE.
Example: With MAX_IO_SIZE= 128K
the default storage for the initial and next extent
must be = (128 * 1024) = 131072 bytes.
MAX_IO_SIZE is an Operating system dependant