ORA-01410: invalid ROWID

This error will occur if you are trying to find the row from a table using the ROWID which does not exist in the table.

Example:


SQL> select * from dual where rowid='a';
select * from dual where rowid='a'
                               *
ERROR at line 1:
ORA-01410: invalid ROWID


SQL> select rowid from dual;

ROWID
------------------
AAAAB0AABAAAAOhAAA

SQL> select * from dual where rowid ='AAAAB0AABAAAAOhAAA';

D
-
X