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

### 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

 

 

转载于:https://www.cnblogs.com/liuyongcn/p/4232390.html