Re: ORA-01410: invalid ROWID

wiggam14 <member22780_at_dbforums.com> wrote in message news:<2417405.1043166189_at_dbforums.com>...
> This is truly strange. Within our application, we have an auditing
> mechanism with records every insert and update with triggers. A row
> level trigger records the ROWID of the record modified into a Package
> variable. An after statement trigger reads this ROWID from the package
> variable and selects the database based on it. This has been working
> perfectly for about a year, until this week. Now the application is
> throwing ORA-01410: invalid ROWID. The errors are not consistent at
> all. In fact they seem pretty varied. It doesn't happen on EVERY
> insert / update and it doesn't happen on every table which uses this
> mechanism.
>
> The only thing we know about that was done before these errors started
> was a full database export with CONSISTENT=N. The export was kicked off
> and 10 mins later was the first records instance of this error. I'm
> having a hard time dealing with how the export could cause this, but the
> correlation seems too significant. We've tried fixing the problem by
> ANALYZE TABLE <table_name> VALIDATE STRUCTURE on the tables in question.
> No errors were recorded and we are still having the same problems. Our
> next idea is to rebuild the tables in question.
>
> So, anyone have any idea what's going on? And does anyone have a
> better solution?

No solution, but I'll throw out some wild ideas. First the obvious, have you checked the alert log for errors? Have you check the objects involved are VALID?

Second, try creating a new user and importing the table and any foreigns with these row id's. Perhaps you have some data size/format issue that you didn't think of. What version/platform? Have you updated from 7 to 8, perhaps?

Third, the dbverify utility. Ya never know...

And those privileges with packages... you wouldn't happen to be using dblinks?

>
> Thanks

jg

--
_at_home is bogus.
.egassem terces eht derevocsid ev'uoy