I wonder if the rowid will change during an update of a partition key? For example, say you have a table partitioned on trasaction_dt by month. Each of your months is in a seperate tablespace. If you update the value of transaction_dt so that it moves from one partition to the next, I wonder if that would change the rowid of the row that is locked? Probably not until the change is committed, but something to think about...

(sambavan: you're really started something now... )

[Edited by marist89 on 05-07-2001 at 05:12 PM]