All Oracle Error CodesOracle DBA Forum

ORA-01947:

TEMPORARY TABLESPACE already specified
Cause: The temporary tablespace clause has been given twice.
Action: Use only one temporary tablespace clause.