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@(protected)
[mailto:oracle-l-bounce@(protected)]On Behalf Of Mladen Gogala
Sent: Thursday, August 26, 2004 7:39 AM
To: oracle-l@(protected)
Subject: Re: Oracle Error ORA-01401 (See ORA-01401.ora-code.com) ...
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 (See ORA-01410.ora-code.com): 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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
