Re: Tracing an ORA-01410 error
- From: Yong Huang <yong321@xxxxxxxxx>
- To: peter.schauss@xxxxxxx
- Date: Sat, 7 Feb 2009 15:07:53 -0800 (PST)
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
