ORA-01654:无法扩展索引 [英] ORA-01654: unable to extend index
本文介绍了ORA-01654:无法扩展索引的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
调用所有Oracle专家!
Calling all Oracle Gurus!
我正在将经过充分测试的应用程序集群到WebSphere上。有问题的应用程序使得它在发生这种情况之前从队列处理1k个JMS消息的一半时间。
I am in the process of clustering a well tested application on WebSphere. The application in question made it about half way through processing 1k of JMS messages from a queue before this happened.
---- Begin backtrace for Nested Throwables
java.sql.SQLException: ORA-01654: unable to extend index DABUAT.INDEX1 by 128 in tablespace DABUAT_TBLSP
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
我有我在网上快速浏览了一下,并找到了一些可能的建议,为什么会发生这种情况,如果有人能够清楚地解释为什么现在可能已经发生这种情况,我的应用程序已被集群化,我将非常感激。
I have had a quick look online and found a few possible suggestions as to why this could have happend, if anyone could give a clear explanation as to why this may have occurred now my application has been clusterd I would be most grateful.
问候Karl
推荐答案
您的磁盘空间不足。
增加 TABLESPACE
:
ALTER TABLESPACE DABUAT_TBLSP
ADD DATAFILE 'C:\FolderWithPlentyOfSpace\DABUAT_TBLSP001.DBF'
SIZE 4M
AUTOEXTEND ON NEXT 4M
MAXSIZE 64G;
-- Put your own size parameters here
这篇关于ORA-01654:无法扩展索引的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文