ORA-1410 Invalid ROWID Mystery

8 06 2010

June 8, 2010

An interesting thread appeared on the OTN forums today.  The original poster indicated that he was running Oracle Database 10.2.0.2 on Windows 2003 R2, and received an unexpected error message:

SQL> analyze table ap2dw.ist_perfaggr_r_7 validate structure cascade;
analyze table ap2dw.ist_perfaggr_r_7 validate structure cascade
*
ERROR at line 1:
ORA-01410: invalid ROWID

The OP stated that the table is truncated and reloaded every night and that there are no indexes on the table (the index was dropped and the error remains).  The OP bounced the server and the problem disappeared.  What was the cause of the problem?


Comments : 3 Comments »

Categories : General Administration