ORA-00959: tablespace 'PSAPTEMP' does not exist

错误 : ORA-00959: tablespace ‘PSAPTEMP‘ does not exist

解决办法:

CREATE TEMPORARY TABLESPACE PSAPTEMP  TEMPFILE ‘E:/Oracle/ORC/sapdata3/temp_1/temp.data1‘ SIZE 500M REUSE AUTOEXTEND ON  NEXT 100M MAXSIZE unlimited EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;


ALTER DATABASE DEFAULT TEMPORARY TABLESPACE PSAPTEMP;

ORA-00959: tablespace 'PSAPTEMP' does not exist

原文：http://www.cnblogs.com/xuyuanjia/p/6120170.html