Don't bother trying to use anything but uniform-sized extents in a temporary tablespace... SQL> create temporary tablespace t2 tempfile '/tmp/t2.dbf' size 10M 2 extent management local autoallocate; extent management local autoallocate * ERROR at line 2: ORA-25139: invalid option for CREATE TEMPORARY TABLESPACE Sometimes, it¹s better not to have options... :-) on 1/29/04 1:05 PM, Mladen Gogala at mladen@xxxxxxxxxxxxxxx wrote: > It depends. If you can create sort_area_size that can dynamically > autoallocate larger and larger chunks of memory, then go ahead, create > autoallocate temporary tablespace. If your sort_area_size is fixed, > then you should create temporary tablespace with the uniform extent > size. > > On 01/29/2004 02:54:37 PM, Jeffrey Beckstrom wrote: >> Is it better to create the temporary tablespace with uniform >> allocation or autoallocate. >> >> >> >> Jeffrey Beckstrom >> Database Administrator >> Greater Cleveland Regional Transit Authority >> 1240 W. 6th Street >> Cleveland, Ohio 44113 >> >> ---------------------------------------------------------------- >> Please see the official ORACLE-L FAQ: http://www.orafaq.com >> ---------------------------------------------------------------- >> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx >> put 'unsubscribe' in the subject line. >> -- >> Archives are at //www.freelists.org/archives/oracle-l/ >> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html >> ----------------------------------------------------------------- >> > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------