ORA-01410: invalid rowid

gs79
gs79 used Ask the Experts™
on
I got this error when I was doing a massive insert/update on a table (merge). The procedure has multiple procedures with in itself which involves truncating the temp tables, fetching data into temp tables and the some transformations on temp tables before insert/updating the target table..

When I re-ran the procedure again, the error didnt occur..

So what are the circumstances this error occurs? How to catch the erroneous rowid when the error occurs..

Please advice..

Thanks.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Burleson has given some information on this.. check out the site...

http://www.dba-oracle.com/t_ora_01410_invalid_rowid.htm

if the error is not recurring then how can you know where the error had occured??

check out the site may be you are using some formats, which needs to be corrected in your procedures accordingly...!!!

Author

Commented:
I was not able to reproduce this error..however i believe the reasons mentioned in the above link are some of the reasons ..thanks for sharing

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial