Java ORA-01654: 无法扩展索引
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/768920/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
ORA-01654: unable to extend index
提问by Karl
Calling all Oracle Gurus!
召集所有 Oracle 大师！
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.
我正在对 WebSphere 上经过良好测试的应用程序进行集群。在这之前，有问题的应用程序已经处理了来自队列的 1k 条 JMS 消息。
---- 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.
我在网上快速浏览了一下，发现了一些关于为什么会发生这种情况的可能建议，如果有人能清楚地解释为什么现在我的应用程序已经被聚集，我将不胜感激。
Regards Karl
问候卡尔
采纳答案by Quassnoi
You are out of disk space.
您的磁盘空间不足。
Increase your TABLESPACE:
增加你的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
回答by pedram ezzati
IF you are using ASM then you can add with below comment
如果您使用的是 ASM，那么您可以添加以下评论
you can run below command to get size of datafile
您可以运行以下命令来获取数据文件的大小
SELECT
file_name,
bytes / 1024 / 1024 mb
FROM
dba_data_files
WHERE
tablespace_name = 'APP_DATA'
ORDER BY
file_name;
FILE_NAME mb
------------------------------------------------------------ -------
+DATA/SID/datafile/app_data.dbf 20000
+DATA/SID/datafile/app_data.dbf 28100
Resizing and adding
调整大小和添加
+DATA/path/indx_operational_00.dbf
alter database datafile '+DATA/path/indx_operational_00.dbf' resize 3000m;
