Re: Possibility of changing Rowid because of UPDATE operations
- From: Mladen Gogala <mladen@xxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 16 Mar 2004 15:06:30 -0500
On 03/16/2004 01:52:49 PM, Prasada.Gunda@xxxxxxxxxxxxxxxx wrote:
>
> 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
>
Justin told you about the IOT's. Furthermore, if you have clustered tables and
if the cluster key is
updated, row is physically moved from one place to another, thereby changing
the rowid.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
