ORA-01410:Invalid ROWID
上一篇 /
下一篇 2007-08-04 00:00:00
/ 个人分类:oracle
解决ORA-01410:Invalid ROWID的一般步骤
===========================================================
1.使用ANALYZE TABLE <table> VALIDATE STRUCTURE CASCADE验证表和索引中的rowid是否有效.
2.设置event = "1410 trace name errorstack level 3" 跟踪,分析跟踪文件.
"
My suggestion:
1)do the above steps,
1)possibly the index of this table needs rebuild
2)data file corruption: use dbverify
Example
To verify the integrity of the data01.dbf data file, starting with block 1 and
ending with block 500, you execute the following command:
UNIX
$ dbv /users/DB00/u03/data01.dbf start=1 end=500
This should be similar to "analyze table"
Hope this is helpful.
导入论坛
引用链接
收藏
分享给好友
推荐到圈子
管理
举报
TAG: