Originally posted by Thomasps
What about this?
Code:
SQL> create tablespace test
  2  datafile 'D:\ORACLE\ORADATA\TEST10G\test00003.dbf' size 10M
  3  extent management local;

Tablespace created.
What? The error is to with create temporary tablespace syntax. Not sure what you're demostrating here.

Either omit the extent management clause altogether for the temp tablespace or do as oracldoc suggests