RE: MAX_IO_SIZE and Temp Next Extent approach to ORA-03232 Error

2002-02-10 Thread Larry Elkins
, 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

Re: MAX_IO_SIZE and Temp Next Extent approach to ORA-03232 Error

2002-02-08 Thread claudio cutelli
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