Re: Are rowids unique among tables?

From: Roman Starek <starek_at_pluto.spsselib.hiedu.cz>
Date: 6 Oct 2000 10:27:16 GMT
Message-ID: <8rk9e4$bvs$1@crax.cesnet.cz>

pku12345_at_my-deja.com wrote:
: By definition, a rowid identifies the storage location of a row within
: a datafile/extent/block. Since no two rows (from the same table or
: otherwise) can physically occupy the same space, rowids are unique
: through out a given database. I don't know why your last query didn't
: work though -- curious....

Two rows can occupy the same physical location. This is the case of clustered tables where rows with the same cluster key are stored on the same place.

STarous Received on Fri Oct 06 2000 - 05:27:16 CDT