Re: Tracing an ORA-01410 error
From: Yong Huang <yong321_at_yahoo.com>
Date: Sat, 7 Feb 2009 15:07:53 -0800 (PST)
Message-ID: <962859.61391.qm_at_web80604.mail.mud.yahoo.com>
As Stefan pointed out, the error stack in the trace file won't help you much, except in the sense that you find the same or similar error stack on Metalink. In your case, it's probably "bug" 7257258, which is clearly explained in Note:727597.1 (Getting ORA-1410 When Running Select Against Partition or Subpartition With Active Exchange). You can compare your error stack with that in the bug report. If you have exchange partition in your ETL code, it most likely matches the "bug", and honestly there's really nothing Oracle can do to help you avoid this error.
Date: Sat, 7 Feb 2009 15:07:53 -0800 (PST)
Message-ID: <962859.61391.qm_at_web80604.mail.mud.yahoo.com>
As Stefan pointed out, the error stack in the trace file won't help you much, except in the sense that you find the same or similar error stack on Metalink. In your case, it's probably "bug" 7257258, which is clearly explained in Note:727597.1 (Getting ORA-1410 When Running Select Against Partition or Subpartition With Active Exchange). You can compare your error stack with that in the bug report. If you have exchange partition in your ETL code, it most likely matches the "bug", and honestly there's really nothing Oracle can do to help you avoid this error.
Yong Huang
> Oracle 8.1.7.4/ Solaris 9
>
> Some of our user reports are failing with ORA-1401- invalid rowid
> errors. Searching the archives I found a suggestion that I turn on
> tracing for this error with the command:
>
> alter session set events '1440 trace name errorstack forever, level 3';
>
> What kind of information can I expect to get from this trace?
>
> Thanks,
> Peter Schauss
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Feb 07 2009 - 17:07:53 CST