Is there possible that 1 rowid will be shared by 2 different records
( from same table or different table)
Printable View
Is there possible that 1 rowid will be shared by 2 different records
( from same table or different table)
Rows in different tables that are stored together in the same cluster can have the same rowid.
there may be a chance when we do import by tranportable tablespaces
Nope, this is not possible.Quote:
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.Quote:
Originally posted by mallika
there may be a chance when we do import by tranportable tablespaces
I distinctly remember reading that one circumstance in which a rowid could be non-unique was in a database with tablespaces transported in. Hmmm.