首页 > 代码库 > 【异常】ORA-01536: space quota exceeded for tablespace

【异常】ORA-01536: space quota exceeded for tablespace

2024-11-08 12:34:38   204人阅读


### The error may exist in /src/main/resources/com/star/css/dao/sql/workflow.xml
### The error may involve COM.STAR.insertHistoryStep-Inline
### The error occurred while setting parameters
### SQL: insert into WORKFLOWSTEPEN ( WORKFLOWSTEPID_PK,BEGINDATE,WORKFLOWINSTANCEID_FK,ISMANUAL,DETAILMESSAGE,PROCESSORID,COMPLETEDATE,OPERATORID,OPERATEDATE, statusid,name_,code_,MEM,CREATEID,MODIFYID,MODIFYDT ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, 1, ?, ?, ?, ?, ?, ? )
### Cause: java.sql.SQLException: ORA-01536: space quota exceeded for tablespace ‘TBLCSS‘
; uncategorized SQLException for SQL []; SQL state [72000]; error code [1536]; ORA-01536: space quota exceeded for tablespace ‘TBLCSS‘
; nested exception is java.sql.SQLException: ORA-01536: space quota exceeded for tablespace ‘TBLCSS‘
 at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
 at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
 at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
 at com.star.platform.sm.spring.DAOPlatformExceptionTranslator.translateExceptionIfPossible(DAOPlatformExceptionTranslator.java:72)
 at com.star.platform.sm.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:350)
 at $Proxy2.insert(Unknown Source)
 at com.star.platform.sm.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:222)
 at com.star.platform.sm.session.SessionImpl.insert(SessionImpl.java:162)
 at com.star.css.dao.WorkflowDao.addHistoryStep(WorkflowDao.java:33)
 at com.star.css.wokrorderdispach.service.AutoCheckWorkOrderService.check(AutoCheckWorkOrderService.java:85)
 at com.star.css.schedule.workflow.service.CheckWorkOrder.execute(CheckWorkOrder.java:43)
 ... 68 more
Caused by: java.sql.SQLException: ORA-01536: space quota exceeded for tablespace ‘TBLCSS‘
 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
 at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
 at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
 at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
STARCSS的异常
insert into WORKFLOWSTEPEN ( WORKFLOWSTEPID_PK,BEGINDATE,WORKFLOWINSTANCEID_FK,ISMANUAL,DETAILMESSAGE,PROCESSORID,COMPLETEDATE,OPERATORID,OPERATEDATE, statusid,name_,code_,MEM,CREATEID,MODIFYID,MODIFYDT ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, 1, ?, ?, ?, ?, ?, ? )
### Cause: java.sql.SQLException: ORA-01536: space quota exceeded for tablespace ‘TBLCSS‘
 
问题原因：添加表时用户在使用表空间“TBLCSS”时候受到了权限的限制
 
修改方式：修改这个用户的使用这个表空间的空间的权限就可以了.
ALTER USER <username> QUOTA UNLIMITED ON <tablespacename>
例如：
ALTER USER SMS5449R1 QUOTA UNLIMITED ON TBLCSS
 
 

【异常】ORA-01536: space quota exceeded for tablespace


联系
我们