ROWID Duplicated ?

[ligang]

Is there possible that 1 rowid will be shared by 2 different records
( from same table or different table)

[slimdave]

Rows in different tables that are stored together in the same cluster can have the same rowid.

[mallika]

there may be a chance when we do import by tranportable tablespaces

[nagarjuna]

Originally posted by mallika
there may be a chance when we do import by tranportable tablespaces

Nope, this is not possible.

[slimdave]

Originally posted by mallika
there may be a chance when we do import by tranportable tablespaces

You know, I remember reading about this a long time ago, and it makes sense really. I can't find a mention of it in the 9iR2 docs, though.

I distinctly remember reading that one circumstance in which a rowid could be non-unique was in a database with tablespaces transported in. Hmmm.