Last updated on MAY 12, 2017
Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.2 to 10.2.0.5 [Release 10.1 to 10.2]
Information in this document applies to any platform.
***Checked for relevance on 24-Apr-2012***
You might be getting intermittent ORA-01410 "Invalid ROWID" errors on application queries involving Partitioned Tables while no DDL activities going on on the objects involved in the query. You can't always reproduce the error from SQL*Plus.
Setting a Systemstate dump for the ORA-01410 to show if any DDLs are taking place at the
time of the error, it indeed showed an index rebuild for one of the objects involved in the query.
A process for one of the objects involved in the query looked like :
Steps to confirm symptoms :
- Set a Systemstate for the ORA-01410 to check for DDLs at time of the error.
SQL> alter system set events '1410 trace name systemstate level 266'
- Once you have the file, you should see a statement doing a DDL for either of the objects involved in the query. If the trace file has an Explain Plan, use each object involved in the query from that Plan Table and search in the trace file for any other statements involving either of the objects.
- You could very much find a process/ cursor that's executing a DDL for either of the objects involved in the query. If found, then that explains the ORA-01410.
It's expected sometimes to get ORA-01410 for queries when DDLs ( for example index rebuilds ) are going on to the same objects involved in the queries around the same time.
Related bug reports:
Unpublished Bug 5663687 ORA-1410 ON QUERY WHILE INDEX REBUILD ONLINE IS OCCURRING
<Bug 6977405> ORA-1410 ON PARTITIONED INDICES AFTER ONLINE REBUILD
<Bug 4151427> ORA-1410 OCCURS AFTER INDEX REBUILD ONLINE
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms