Getting ORA-01410 for Partitioned Tables Without Any Apparent DDL On The Partitions. (Doc ID 887659.1)

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***

Symptoms

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 :

  1. 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'

  2. 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.

  3. 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.

Changes

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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms