Temporary Tablesapce

[kris109]

It should be TEMPFILE not DATAFILE. Your syntax is for locally managed temporary tablespace hence use extent management local uniform size 100K.

CREATE TEMPORARY TABLESPACE TEMP
TEMPFILE 'D:\ERP\TEMP.DBF' SIZE 1000M REUSE AUTOEXTEND ON
EXTENT MANGEMENT LOCAL UNIFORM SIZE 100K;