Database Administration (MOSC)

MOSC Banner

Using rowid in where clause?

edited Sep 19, 2014 10:44AM in Database Administration (MOSC) 2 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center