Oracle Database Discussions

Hi,

There is the requirement that the TEMP tablespace are autoextensible in the existing database.

here is the result:

select count(*) from dba_temp_files where tablespace_name='TEMP' and AUTOEXTENSIBLE <> 'YES';

COUNT(*)
----------------------
1

select FILE_NAME, TABLESPACE_NAME, AUTOEXTENSIBLE from dba_temp_files where tablespace_name='TEMP';



FILE_NAME TABLESPACE_NAME AUTOEXTENSIBLE
---------------------------------------------- ------------------------------ --------------
/oracle/ora_data/data/FMW1U/temp_01.dbf TEMP NO


My question is how can I enable AUTOEXTENSIBLE for this TEMP tablespace?

Cheers
Julia