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
，