ORA-01410: invalid ROWID或ORA-08103: object no long

ORA-01410: invalid ROWID或ORA-08103: object no longer exists

我在oracle 9206版本中执行exp　direct=y时有时会发生以下错误．

ORA-08103: object no longer exists
或
ORA-01410: invalid ROWID
这个错误

你可以先analyze  table  validate structure;如果确定没有逻辑坏块的话，那就是碰到bug了.oracle说当你用direct=y导出数据时，如果有大量的insert操作，有可能会发生以上错误，解决方法就是打patch或不用direct=y导出

 

原因:

 Bug 3868753
Abstract: Concurrent export / INSERT of ASSM segment can fail with ORA-1410 / ORA-8103
Versions affected: 9.2.0.5 & 9.2.0.6
Fixed in version: 9.2.0.7, 10.1.0.5 & 10.2
Symptoms:
Concurrent inserts and exports on ASSM tables may generate ORA-8103/ORA-1410 errors.
Details:
Concurrent INSERTS and direct path EXPORT against ASSM tables can fail th ORA-8103 and ORA-1410 errors.
Workaround:
Do not use direct path EXPORT against ASSM tables
Patch details:
One-off patch available for few platforms on top of 9.2.0.5, 9.2.0.6 & 10.1.0.3, 10.1.0.4
Check the Metalink for Patch 3868753 availability.

 

Workround:

在exp时不要用direct=Y