<div>
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
</div>


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

<div>
<div class="content wysiwyg-content">
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..<br />
<br />
When I re-ran the procedure again, the error didnt occur..<br />
<br />
So what are the circumstances this error occurs? How to catch the erroneous rowid when the error occurs..<br />
<br />
Please advice..<br />
<br />
Thanks.
</div>
</div>


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.

ORA-01410: invalid rowid

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.