ORA-1693: max # extents 505 错误解决办法
来源:互联网 发布:mac有好用的看图软件吗 编辑:程序博客网 时间:2024/05/01 03:58
今天上午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
- ORA-1693: max # extents 505 错误解决办法
- ORA-1628: max # extents 32765 reached for rollback segment 错误处理
- ORACLE 8i 遇到报错:ORA-01631: max # extents (505) reached in table
- ORA-01628:max # extents (32765) reached for rollback segment _SYSSMU613$
- ORA-01628:max # of extents num reached for rollback segment num !
- ORA-16014错误解决办法
- ORA-00600 错误解决办法
- Ora-27100错误解决办法
- ORA-20446 错误解决办法
- ORA-01653错误解决办法
- ORA-01653错误解决办法
- ORA-16014错误解决办法
- ORA-16014错误解决办法
- ORA-27101,ORA-01034错误解决办法
- ORA-01034,ORA-27101 错误的解决办法
- 【ORA】ORA-4031错误分析和解决办法
- ORA-01034错误的解决办法
- ORA-01034错误的解决办法
- js 复制到剪贴板函数
- 请问屋子里有多少人
- 动态语言静态语言
- 体检之二:至尊套餐体检项目
- android学习路线
- ORA-1693: max # extents 505 错误解决办法
- C#-文件目录-文件目录操作
- DYNP_VALUES_READ
- map中用CString作为键或值,不要直接传字符窜
- Java 模拟键盘输入的小Demo
- ”世人听完先是给了5ooo多一颗丹就能培养一个剑皇级高手的丹药
- ”雷云嘴中出低吟声
- Java类集 _ Stack类
- Rails中应用auto_complete插件实现同步查询