select XH,XZSBH,XM,SFZH,CSRQ,XB,GZ,DJ, LLCJ,JNCJ,PDCJ,SQGJ,YZSBH,YXDZ,FZRQ,BZ,JTZZ from LDJDZX.CX_CGHZ where 1=1 order by DJRQ desc 错误信息:ORA-03212:无法在本地管理的表空间创建临时段
"ORA-03212: 无法在本地管理的表空间创建临时段 Start server side stack trace: java.sql.SQLException: ORA-03212: 无法在本地管理的表空间创建临时段 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405) at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:889) at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1681) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1870) at oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:5303) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:544) at weblogic.jdbc.pool.Statement.executeQuery(Statement.java:850) at weblogic.jdbc.rmi.internal.StatementImpl.executeQuery(StatementImpl.java:79) at weblogic.jdbc.rmi.internal.StatementImpl_WLSkel.invoke(Unknown Source) at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:298) at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:267) at weblogic.rmi.internal.BasicExecuteRequest.execute(BasicExecuteRequest.java:22) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120) End server side stack trace " "<ggl.db.DbBaseManage><executeQuery><sql语句执行错误>[ErrorCode[3212],Message:ORA-03212: 无法在本地管理的表空间创建临时段 Start server side stack trace: java.sql.SQLException: ORA-03212: 无法在本地管理的表空间创建临时段 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405) at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:889) at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1681) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1870) at oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:5303) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:544) at weblogic.jdbc.pool.Statement.executeQuery(Statement.java:850) at weblogic.jdbc.rmi.internal.StatementImpl.executeQuery(StatementImpl.java:79) at weblogic.jdbc.rmi.internal.StatementImpl_WLSkel.invoke(Unknown Source) at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:298) at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:267) at weblogic.rmi.internal.BasicExecuteRequest.execute(BasicExecuteRequest.java:22) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120) End server side stack trace SQLState:99999]"
你上边执行代码的默认临时表空间是什么呢? select username,TEMPORARY_TABLESPACE,DEFAULT_TABLESPACE from dba_users where username='大写用户名'; 很有可能该用户默认的临时表空间是个permanent的~ 1、可以创建一个临时表空间 create temporary tablespace tempbak tempfile 'd:\****\tempbak.dbf' size 100M reuse autoextend on extent management local uniform size 1M ;2、更改用户的临时表空间 alter user scott temporary tablespace temp2;
Error: ORA-3212 Text: Temporary Segment cannot be created in locally-managed tablespace --------------------------------------------------------------------------- Cause: Attempt to create a temporary segment for sort/hash/lobs in in permanent tablespace of kind locally-managed Action: Alter temporary tablespace of user to a temporary tablespace or a dictionary-managed permanent tablespace
Start server side stack trace:
java.sql.SQLException: ORA-03212: 无法在本地管理的表空间创建临时段 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:889)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1681)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1870)
at oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:5303)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:544)
at weblogic.jdbc.pool.Statement.executeQuery(Statement.java:850)
at weblogic.jdbc.rmi.internal.StatementImpl.executeQuery(StatementImpl.java:79)
at weblogic.jdbc.rmi.internal.StatementImpl_WLSkel.invoke(Unknown Source)
at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:298)
at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:267)
at weblogic.rmi.internal.BasicExecuteRequest.execute(BasicExecuteRequest.java:22)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)
End server side stack trace
"
"<ggl.db.DbBaseManage><executeQuery><sql语句执行错误>[ErrorCode[3212],Message:ORA-03212: 无法在本地管理的表空间创建临时段
Start server side stack trace:
java.sql.SQLException: ORA-03212: 无法在本地管理的表空间创建临时段 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:889)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1681)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1870)
at oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:5303)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:544)
at weblogic.jdbc.pool.Statement.executeQuery(Statement.java:850)
at weblogic.jdbc.rmi.internal.StatementImpl.executeQuery(StatementImpl.java:79)
at weblogic.jdbc.rmi.internal.StatementImpl_WLSkel.invoke(Unknown Source)
at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:298)
at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:267)
at weblogic.rmi.internal.BasicExecuteRequest.execute(BasicExecuteRequest.java:22)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)
End server side stack trace
SQLState:99999]"
select username,TEMPORARY_TABLESPACE,DEFAULT_TABLESPACE from dba_users where username='大写用户名';
很有可能该用户默认的临时表空间是个permanent的~
1、可以创建一个临时表空间
create temporary tablespace tempbak
tempfile 'd:\****\tempbak.dbf' size 100M reuse autoextend on
extent management local uniform size 1M ;2、更改用户的临时表空间
alter user scott temporary tablespace temp2;