Oracle Error ORA-01947: TEMPORARY TABLESPACE already specified

Oracle Error Message

ORA-01947: TEMPORARY TABLESPACE already specified

Reason for the Error

The temporary tablespace clause has been given twice.

Solution

Use only one temporary tablespace clause.