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