ORA-01654: unable to extend index
来源:互联网 发布:激光切割机怎么编程 编辑:程序博客网 时间:2024/06/05 00:12
This is a summary of the solution for issue "ORA-01654: unable to extend index ..." from internet.
1) Check table space usage.
SELECT UPPER(F.TABLESPACE_NAME) "TblSpName",
D.TOT_GROOTTE_MB "TblSpCap(M)",
D.TOT_GROOTTE_MB - F.TOTAL_BYTES "Used(M)",
TO_CHAR(ROUND((D.TOT_GROOTTE_MB - F.TOTAL_BYTES) / D.TOT_GROOTTE_MB * 100,2),'990.99') "UsedPercentage",
F.TOTAL_BYTES "Free(M)",
F.MAX_BYTES "MaxBlock(M)"
FROM (SELECT TABLESPACE_NAME,
ROUND(SUM(BYTES) / (1024 * 1024), 2) TOTAL_BYTES,
ROUND(MAX(BYTES) / (1024 * 1024), 2) MAX_BYTES
FROM SYS.DBA_FREE_SPACE
GROUP BY TABLESPACE_NAME) F,
(SELECT DD.TABLESPACE_NAME,
ROUND(SUM(DD.BYTES) / (1024 * 1024), 2) TOT_GROOTTE_MB
FROM SYS.DBA_DATA_FILES DD
GROUP BY DD.TABLESPACE_NAME) D
WHERE D.TABLESPACE_NAME = F.TABLESPACE_NAME
ORDER BY 4 DESC;
2) Basically if we encounter this issue, it means the table space is used up. Login as sysdba and add more space to the correct tablespace.
SQL> alter tablespace SYSTEM add datafile 'SYSTEM2.dbf' size 1G autoextend on next 1G maxsize 2G;
Tip:
Different kinds of users may have different tablespace. Please decide the correct tablespace name that the user is currently using. We can find the tablespace name by
SQL> select tablespace_name from dba_data_files;
References:
http://www.cnblogs.com/kevinsun/archive/2006/03/03/342265.html
http://www.diybl.com/course/6_system/linux/linuxjq/20110827/559046.html
SQL Language Reference 11g
1) Check table space usage.
SELECT UPPER(F.TABLESPACE_NAME) "TblSpName",
D.TOT_GROOTTE_MB "TblSpCap(M)",
D.TOT_GROOTTE_MB - F.TOTAL_BYTES "Used(M)",
TO_CHAR(ROUND((D.TOT_GROOTTE_MB - F.TOTAL_BYTES) / D.TOT_GROOTTE_MB * 100,2),'990.99') "UsedPercentage",
F.TOTAL_BYTES "Free(M)",
F.MAX_BYTES "MaxBlock(M)"
FROM (SELECT TABLESPACE_NAME,
ROUND(SUM(BYTES) / (1024 * 1024), 2) TOTAL_BYTES,
ROUND(MAX(BYTES) / (1024 * 1024), 2) MAX_BYTES
FROM SYS.DBA_FREE_SPACE
GROUP BY TABLESPACE_NAME) F,
(SELECT DD.TABLESPACE_NAME,
ROUND(SUM(DD.BYTES) / (1024 * 1024), 2) TOT_GROOTTE_MB
FROM SYS.DBA_DATA_FILES DD
GROUP BY DD.TABLESPACE_NAME) D
WHERE D.TABLESPACE_NAME = F.TABLESPACE_NAME
ORDER BY 4 DESC;
2) Basically if we encounter this issue, it means the table space is used up. Login as sysdba and add more space to the correct tablespace.
SQL> alter tablespace SYSTEM add datafile 'SYSTEM2.dbf' size 1G autoextend on next 1G maxsize 2G;
Tip:
Different kinds of users may have different tablespace. Please decide the correct tablespace name that the user is currently using. We can find the tablespace name by
SQL> select tablespace_name from dba_data_files;
References:
http://www.cnblogs.com/kevinsun/archive/2006/03/03/342265.html
http://www.diybl.com/course/6_system/linux/linuxjq/20110827/559046.html
SQL Language Reference 11g
- Oracle: ORA-01654 unable to extend index
- ORA-01654: unable to extend index
- ora-01654 unable to extend index
- ora-01654 ORA-01654: unable to extend index HRERP.INDEX_DATE by 128 in tablespace
- ORA-01654: unable to extend index 表空间不够报错
- ORA-01653: unable to extend table
- ORA-01653: unable to extend table
- ORA-01653: unable to extend table
- ORA-1652: unable to extend temp segment
- ORA-1652: unable to extend temp segment诊断以及解决
- 遇到ORA-01691: unable to extend lob segment问题
- ORACLE ORA-01653: unable to extend table 的错误
- ORA-01652: unable to extend temp segment by 8192...
- ORACLE ORA-01653: unable to extend table 的错误
- ORACLE ORA-01653: unable to extend table 的错误
- ORA-01691: unable to extend lob segment 问题解决
- ORACLE ORA-01653: unable to extend table 的错误(转)
- ORA-01691: unable to extend lob segment 问题解决
- OVCS 视频会议系统 Demo
- 自动化测试原理(转载)
- 复习struts2之Action配置的各项默认值
- django 网址127.0.0.0:8000 在别的计算机上打不开怎么办
- 自己写的一个遮罩层插件
- ORA-01654: unable to extend index
- 用mina进行文件传输
- Pycassa 起步——python 与 cassandra
- 常用Emacs命令整理
- DirectX9 SDK Samples(20) MeshFromObj Sample
- 上传图片
- 网页设计中常见的错误
- 【Android 开发教程】TableLayout表格布局
- 中国市场Android终端App兼容性质量报告