Issue : Error while adding another file to the existing temporary tablespace
ALTER TABLESPACE temp ADD datafile '<path>/temp.dbf' size 1G reuse;
ALTER TABLESPACE temp ADD datafile '<path>/temp.dbf' size 1G reuse*
ERROR at line 1: ORA-03217: invalid option for alter of TEMPORARY TABLESPACE
Solution :
you need to use the TEMPFILE clause, not the DATAFILE clause when working with temporary tablespaces, otherwise you will receive the error ORA-03217
ALTER TABLESPACE temp ADD TEMPFILE '<path>/temp.dbf' size 1G reuse;
Tags:
Oracle