Accessing object

[bang_dba]

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

[ggnanaraj]

Hi

Check this out...

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

Cheers.

[rohitsn]

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:

[bang_dba]

hi rhohit
I don't think it is possble for oracle to store rowids
of all the rows in the dictionary, that would consume
lot of space....