ORA-1693:max#extents505错误解决办法

ORA-1693: max # extents 505 错误解决办法

今天上午erp db的alert.log 突然跑出N多ORA-1693错误一开始有点蒙

ARC1: Completed archiving log 1 thread 1 sequence 343118 Fri Sep 9 09:52:55 2011

ORA-1693: max # extents 505 reached in lobsegment APPLSYS.SYS_LOB0001182584C00040$$

ORA-1693: max # extents 505 reached in lobsegment APPLSYS.SYS_LOB0001182584C00040$$

ORA-1693: max # extents 505 reached in lobsegment APPLSYS.SYS_LOB0001182584C00040$$

ORA-1693: max # extents 505 reached in lobsegment APPLSYS.SYS_LOB0001182584C00040$$

ORA-1693: max # extents 505 reached in lobsegment APPLSYS.SYS_LOB0001182584C00040$$

ORA-1693: max # extents 505 reached in lobsegment APPLSYS.SYS_LOB0001182584C00040$$

ORA-1693: max # extents 505 reached in lobsegment APPLSYS.SYS_LOB0001182584C00040$$

ORA-1693: max # extents 505 reached in lobsegment APPLSYS.SYS_LOB0001182584C00040$$

ORA-1693: max # extents 505 reached in lobsegment APPLSYS.SYS_LOB0001182584C00040$$

ORA-1693: max # extents 505 reached in lobsegment APPLSYS.SYS_LOB0001182584C00040$$

ORA-1693: max # extents 505 reached in lobsegment APPLSYS.SYS_LOB0001182584C00040$$

ORA-1693: max # extents 505 reached in lobsegment APPLSYS.SYS_LOB0001182584C00040$$

ORA-1693: max # extents 505 reached in lobsegment APPLSYS.SYS_LOB0001182584C00040$$

ORA-1693: max # extents 505 reached in lobsegment APPLSYS.SYS_LOB0001182584C00040$$

ORA-1693: max # extents 505 reached in lobsegment APPLSYS.SYS_LOB0001182584C00040$$

网上查询了一下信息 有咨询了一下开发部门 应该是开发部门提交一个request 引起的，解决办法如下

1.查詢現在的表的 maxextents

-------------------------------------------------------------------------------------

select owner,segment_name,segment_type,tablespace_name,extents,max_extents

from dba_segments

where segment_name='SYS_LOB0001182584C00040$$';

2.查詢出引起錯誤的表和字段

--------------------------------------------------------------------------------------------

select owner,table_name,column_name,segment_name

from dba_lobs

where segment_name = 'SYS_LOB0001182584C00040$$';

3. 將maxextents 加大

---------------------------------------------------------------------------------------

alter table APPLSYS.WF_NOTIFICATION_OUT modify lob (USER_DATA.TEXT_LOB) (storage (maxextents 2048));

---------------------------------------------------------------------------------------------

修改之后 OK