Using rowid in where clause?
Is there a way I can write the query below? This is on 11203
SYSTEM @ bsbc1_db06 > select segment_name,bytes, block_id, file_id
2 from dba_extents
3 where dbms_rowid.rowid_block_number(rowid)=1020387
4 and dbms_rowid.rowid_relative_fno(rowid)=8;
where dbms_rowid.rowid_block_number(rowid)=1020387
*
ERROR at line 3:
ORA-01446: cannot select ROWID from, or sample, a view with DISTINCT, GROUP BY, etc.
I'm trying to find the segment name and the bytes against dbms_rowid.rowid_relative_fno(rowid)=8 and dbms_rowid.rowid_block_number(rowid)=1020387
Thanks