Oracle Error ORA-03217: invalid option for alter of TEMPORARY TABLESPACE

Oracle Error Message

ORA-03217: invalid option for alter of TEMPORARY TABLESPACE

Reason for the Error

invalid option for alter of temporary tablespace was specified

Solution

Specify one of the valid options: ADD TEMPFILE, TEMPFILE ONLINE, TEMPFILE OFFLINE