confused about temp tablespace in local extent
I am a bit confused about the temp tablespace in local extent.
below is the script of my temp tablespace in local extent:
CREATE TEMPORARY TABLESPACE TEMP_01
TEMPFILE 'D:\ORADATA\HUOXYD01\TEMP_01.DBF' SIZE 61440K AUTOEXTEND OFF
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024K
/
ok what happened if the user need more than 60M??? can we set the autoextend on for TEMP tablespace??? It seem like we can't b/c I tried the below scripts and it still set autoextend of after I run the script below:
ALTER DATABASE TEMPFILE 'D:\ORADATA\HUOXYD01\TEMP_01.DBF' AUTOEXTEND ON NEXT 10240K MAXSIZE 2048000K
/
So if I can't set the autoextend on, then I have to allocate a certain space for temp tablespaces??? which mean that I have to use a lot of spaces for TEMP tablespaces????
Please correct me if I am wrong and give me some advises