Possibility of changing Rowid because of UPDATE operations

From: <Prasada.Gunda_at_hartfordlife.com>
Date: Tue, 16 Mar 2004 13:52:49 -0500
Message-ID: <OFF8CEA9A9.988BC708-ON85256E59.0066FE2E@hartfordlife.com>

Hello All,

Do you think of any situation where Oracle would change the rowid(or move the row that causes rowid change) under the hood in 8i/9i or even in 10g if there are simply Update operations happen on a row?

I know that the Rowid of the row is not going to change when there is a row chaining/migration. So, this is not an issue. And, I understand that the Rowid would change in other situations like row is deleted/inserted, table is exported/imported, truncated/reloaded or alter table..move and other similar operations.

But, I am only concerned with Update operations. Even in IOT and Cluster tables, I believe Oracle would maintain the same rowid if there is an Update to a row.

Please let me know your thoughts/suggestions.

Ours is a DW environment and would like to use the rowids to identify changes in the source table where there is no primary/unique key.

Thanks in advance,

Best Regards,
Prasad

PRIVILEGED AND CONFIDENTIAL: This communication, including attachments, is for the exclusive use of addressee and may contain proprietary, confidential and/or privileged information. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this communication and destroy all copies.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Tue Mar 16 2004 - 13:49:24 CST