ORA-01652: 无法通过 128 (在表空间 TEMP 中) 扩展 temp 段

The SQL send to excute is: SELECT * FROM (SELECT A.ASSETS_ID as 资产ID, A.ASSETS_NO as 资产编号, A.ASSETS_NAME as 资产名称, B.CATALOG_NAME as 固定资产目录, A.DUTY_PERSON as 责任人, A.MODEL as 规格型号, A.VALUE as 原价值, A.START_USE_DATE as 使用时间, C.NAME as 使用部门, E.CHINA_NAME as 站址名称, E.CODE as 站址编码, F.PROJECT_NO as 工程编号, A.IS_PRODUCE as 是否生产类, A.ASSET_TYPE as 资产类型, SF_GET_DESC_CHINA(A.STATE_ID) as 资产状态, A.STATE_ID,SF_GET_DESC_CHINA(a.prop_char_id) as 资产接收类型, D.NAME as 管理部门 ,ROWNUM AS rn FROM WORK_GROUP D, PUB_FIXED_ASSETS A, PUB_FIXED_ASSETS_CATALOG B, WORK_GROUP C, SPC_STATION E, PUB_PROJECT F WHERE nvl(F.delete_state, '0') = '0' AND nvl(E.delete_state, '0') = '0' AND nvl(C.delete_state, '0') = '0' AND nvl(B.delete_state, '0') = '0' AND nvl(A.delete_state, '0') = '0' AND nvl(D.delete_state, '0') = '0' AND A.MANAGER_DEPT_ID = D.WORK_GROUP_ID(+) AND A.CATALOG_ID = B.CATALOG_ID(+) AND A.STATION_ID = E.STATION_ID(+) AND A.USER_DEPT_ID = C.WORK_GROUP_ID(+) AND A.PROJECT_ID = F.PROJECT_ID(+) AND A.ASSETS_NO IS NOT NULL AND rownum<= 21 ) WHERE rn >= 1
java.sql.SQLException: ORA-04045: 在重新编译/重新验证 RESTW_D.LOGON_DENIED_TO_ALERT 时出错
ORA-01031: 权限不足
ORA-01652: 无法通过 128 (在表空间 TEMP 中) 扩展 temp 段

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:1198)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2400)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2672)
at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:3989)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:623)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:527)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at com.zte.resmaster.dynamicquery.userdefinedquery.dao.UserDefinedQueryDAOOracle.doQuery(UserDefinedQueryDAOOracle.java:2387)
at com.zte.resmaster.dynamicquery.userdefinedquery.dao.UserDefinedQueryDAOOracle.main(UserDefinedQueryDAOOracle.java:2279)

 

 

写的sql出现空间不足问题，网上说的方法查看执行计划貌似没啥问题

sql也没看出什么问题，重新启动可用，不管第一页下一页前一页最后页都可用，迷之微笑，记录下，下次碰见类似问题再看

转载于:https://www.cnblogs.com/dawn1156/p/6769292.html