Temp tablespace in 9i
My db is 9.2.0.4 64 bit on AIX.
With a command to create temporary tablespace such:
CREATE TEMPORARY TABLESPACE TEMP TEMPFILE
'/oradata/bankpri/temp01.dbf' SIZE 100M AUTOEXTEND OFF
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;
And DBA that just leave this position said that it's temp default in oracle 9i. And I'm going to recreate a new temp with:
CREATE TEMPORARY TABLESPACE TEMP
TEMPFILE '/oradata/bankpri/temp01.dbf' SIZE 100M
AUTOEXTEND ON NEXT 20M MAXSIZE unlimited
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;
I think that it should autoextend !
Have any ideas ?
Thanks