今日在创建EM 资料档案库时发生以下异常
oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-00959: 表空间 'TEMP' 不存在
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1467)
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeScript(SQLEngine.java:841)
at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:265)
Solution:
手工创建临时表空间‘TEMP’
create temporary tablespace TEMP
tempfile 'D:/oracle/product/10.2.0/RAOASYS/Data/TEMP.dbf'
size 20M reuse
extent management local uniform size 5M ;
注意DBF Size必须大于uniform size