ROWIDS - EXTENDED/RESTRICTED AGAIN

From: <coakleyj_at_hotmail.com>
Date: Tue, 15 Jun 1999 16:19:52 GMT
Message-ID: <7k5ueq$qeb$1@nnrp1.deja.com>

Hi everyone.

Oracle 8 has a so-called "extended" rowid format. Consequently, a "select vsize(rowid) from dual" will return the value 10 in Oracle 8, (and 6 in Oracle 7).

However, I have read that indexes in Oracle 8 still use the restricted rowid format. Thus, when attempting to calculate the size of an index, the rowid can be treated as 6 bytes and not 10.

Is this true? The one exception, (according to the article I read) is for global indexes on partitioned tables, where the extended rowid format is used within the index and consequently all calculations should use 10 bytes for the length of the rowid in that case.

Can someone put me straight on this please?

Thanks
Coakleyj

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jun 15 1999 - 11:19:52 CDT