SQL> alter tablespace TEMP add tempfile '/u01/app/oracle/oradata/orcl/temp01.dbf' size 5m autoextend on;
alter tablespace TEMP add tempfile '/u01/app/oracle/oradata/orcl/temp01.dbf' size 5m autoextend on
*
ERROR at line 1:
ORA-01119: error in creating database file
'/u01/app/oracle/oradata/orcl/temp01.dbf'
ORA-27038: created file already exists
Additional information: 1
SQL> alter tablespace TEMP add tempfile '/u01/app/oracle/oradata/orcl/temp01.dbf' size 5m autoextend on reuse;
alter tablespace TEMP add tempfile '/u01/app/oracle/oradata/orcl/temp01.dbf' size 5m autoextend on reuse
*
ERROR at line 1:
ORA-00933: SQL command not properly ended
SQL> alter tablespace TEMP add tempfile '/u01/app/oracle/oradata/orcl/temp01.dbf' size 5m reuse autoextend on;
Tablespace altered.
alter tablespace TEMP add tempfile '/u01/app/oracle/oradata/orcl/temp01.dbf' size 5m autoextend on
*
ERROR at line 1:
ORA-01119: error in creating database file
'/u01/app/oracle/oradata/orcl/temp01.dbf'
ORA-27038: created file already exists
Additional information: 1
SQL> alter tablespace TEMP add tempfile '/u01/app/oracle/oradata/orcl/temp01.dbf' size 5m autoextend on reuse;
alter tablespace TEMP add tempfile '/u01/app/oracle/oradata/orcl/temp01.dbf' size 5m autoextend on reuse
*
ERROR at line 1:
ORA-00933: SQL command not properly ended
SQL> alter tablespace TEMP add tempfile '/u01/app/oracle/oradata/orcl/temp01.dbf' size 5m reuse autoextend on;
Tablespace altered.