ORA-1410: invalid ROWID when updating table(二)

What causes ORA-1410

E.G. ROWID:

OOOOOOFFFBBBBBBSSS
O=Data Object Number (length=6)
F=Relative File Number (length=3)
B=Block Number (length=6)
S=Slot Number (length=3)

 

When Oracle parses the rowid (to get the file, block, and slot), if there is no row there, then it is potentially a ORA-1410.

• If the file and block are both valid, and the only problem is that the row slot does not exist, it returns the ‘no rows selected’ message.
• If any other part of the rowid has a problem, then the ORA-1410 is returned and may be cause for concern.

ORA-1410 is often linked with block corruption, because it can be one source of the error. However, there are other sources of the error.

This is a list of possible sources of ORA-1410 errors.

1. The rowid was manually entered incorrectly into a SQL statement. Or a customized PL/SQL procedure has faulty logic and generates an incorrect rowid.
   
2. The rowid was generated internally, but was corrupted while in memory.
3. The rowid was retrieved from an index, which was corrupt. If this is the case, you would expect to see other corruption errors accompanying the ORA-1410.
4. DDL on objects during long running queries which access those objects..  For example, rebuilding an index can cause the ORA-1410 if a SQL statement is accessing the index.
   
5. The rowid was valid, but the data block or datafile was corrupted (overwritten) so the block address may be wrong. If this is the case, you would expect to see other corruption errors accompanying the ORA-1410.
6. The rowid was valid but points to a block that was moved recently. This can occur due to timing, where a table was truncated while a SQL was in progress. Therefore, the SQL has a cached rowid, but the block was removed during the truncation. The same thing can happen if a table partition was exchanged while a SQL statement was running. In this case the file number changed and the SQL statement could report ORA-1410.
7. An Oracle Bug, OS bug, or other application bug.

参考文献：
1. Understanding The ORA-1410 Error [ID 806195.1]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9252210/viewspace-676329/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9252210/viewspace-676329/