All Oracle Error CodesOracle DBA Forum

ORA-02156:

invalid TEMPORARY tablespace identifier
Cause: An identifier does not follow TEMPORARY TABLESPACE.
Action: Place a tablespace name after TEMPORARY TABLESPACE.