My Oracle Support Banner

ORA-01410: Invalid Rowid When Using rowid Generated from V$Session and Dba_objects (Doc ID 603661.1)

Last updated on NOVEMBER 30, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.4 [Release 10.2]
Information in this document applies to any platform.
***Checked for relevance on 26-Mar-2012***


Symptoms

The ROWID generated while using V%SESSION may produce an ORA-1410

select 
 do.object_name, 
 row_wait_obj#, 
 row_wait_file#, 
 row_wait_block#, 
 row_wait_row#, 
 dbms_rowid.rowid_create ( 1, ROW_WAIT_OBJ#, ROW_WAIT_FILE#, ROW_WAIT_BLOCK#, ROW_WAIT_ROW# ) row_id 
from 
 v$session s, 
 dba_objects do 
where 
 sid=&SESSION_Identified
 and s.ROW_WAIT_OBJ# = do.OBJECT_ID;  

OBJECT_NAME ROW_WAIT_OBJ# ROW_WAIT_FILE# ROW_WAIT_BLOCK# ROW_WAIT_ROW# Rowid
------------- -------------- --------------- ------------- ------------------
EMP             9361          47           28349          0 AAACSRAAvAAAG69AAA

select * from emp where rowid='AAACSRAAvAAAG69AAA';
ERROR at line 1: 
ORA-01410: invalid ROWID 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.