Accessing object

Hi everybody,

I just wanted to know, when we issue a sql
statement how oracle finds the location of
the block in the hard disk.(Assuming no index
is built on the table)
Does it store any information of about the object
in the dictionary ? I think rowid is not stored
anywhere, then how oracle searches for the object

Thanks in advance

Hi

Check this out...

http://download-west.oracle.com/docs...sqlpl.htm#1549

Cheers.

Hi,
Oracle does stores the ROWID in its data-dictonary.Oracle finds the location of block using extended ROWID's which is new in Oracle 8 and above.Extended ROWID's consists of the following components: