RE: Oracle Error ORA-01401 ...

Invalid rowid errors can also be received in applications that attempt to fetch data by rowid where the rowid is obtained in one step, and the access by rowid does not take place until much later in the processing, where in between these two events the target row is deleted. The delete would include not only SQL delete statements but also table reorganizations in the case where the rowid to the target table is stored in another table for use in accessing the target row.

HTH -- Mark D Powell --

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Mladen Gogala Sent: Thursday, August 26, 2004 7:39 AM
To: oracle-l_at_freelists.org
Subject: Re: Oracle Error ORA-01401 ...

On 08/26/2004 07:19:51 AM, Harsh Agrawal wrote:
> Hi Xperts,
>
> We are getting the below error while fetching the record using ROWID.
>
> ORA-01410: invalid ROWID
>
> Environment is Solaris 8, Oracle Enterprise Edition 9.2.0.5.
>

Last time I got it was when I playing with DBMS_ROWID package and was trying to
construct my own rowid. The only other situation in which that error would be reported
is data corruption. Did you try "ANALYZE ...VALIDATE STRUCTURE"?

-- 
Mladen Gogala
Oracle DBA
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------