问题描述:数据库警告日志里出现如下几种unable to extend 类错误
ORA-1650: unable to extend rollback segment %s by %s in tablespace %s
ORA-1651: unable to extend save undo segment by %s in tablespace %s
ORA-1652: unable to extend temp segment by %s in tablespace %s
ORA-1653: unable to extend table %s.%s by %s in tablespace %s
ORA-1654: unable to extend index %s.%s by %s in tablespace %s
ORA-1655: unable to extend cluster %s.%s by %s for tablespace %s
ORA-1658: unable to create INITIAL extent for segment in tablespace %s
ORA-1659 unable to allocate MINEXTENTS beyond %s in tablespace %s
ORA-1683: unable to extend index %s.%s partition %s by %s in tablespace %s
ORA-1688: unable to extend table %s.%s partition %s by %s in tablespace %s
ORA-1691: unable to extend lob segment %s.%s by %s in tablespace %s
ORA-1692: unable to extend lob segment %s.%s partition %s by %s in tablespace %s
ORA-3233: unable to extend table %s.%s subpartition %s by %s in tablespace %s
ORA-3234: unable to extend index %s.%s subpartition %s by %s in tablespace %s
ORA-3238: unable to extend LOB segment %s.%s subpartition %s by %s in tablespace %s
问题解决办法:很多时候都会遇到这类“unable to extend”错误,该错误是由于数据库段无法找到连续空间进行扩展导致,即空间不足。
解决表空间不足方法主要有以下几种:
1. 添加数据(临时)文件
ALTER TABLESPACE ADD DATAFILE|TEMPFILE '' SIZE ;
2. 扩展现有数据(临时)文件
ALTER DATABASE DATAFILE|TEMPFILE '' RESIZE ;
3. 将数据(临时)文件改为自动扩展
ALTER DATABASE DATAFILE|TEMPFILE '' AUTOEXTEND ON MAXSIZE ;
4. 修改表段的next_extent大小
ALTER STORAGE ( next pctincrease );
相关知识:
1. 查看表空间最大连续剩余空间
SELECT max(bytes) FROM dba_free_space WHERE tablespace_name = '<tablespace name>';
2. 查看next_extent大小
SELECT NEXT_EXTENT, PCT_INCREASE FROM DBA_SEGMENTS WHERE SEGMENT_NAME = AND SEGMENT_TYPE = AND OWNER =
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29119536/viewspace-1138731/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29119536/viewspace-1138731/