Re: Possibility of changing Rowid because of UPDATE operations
- From: "Jay Hostetter" <jhostetter@xxxxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 16 Mar 2004 15:07:53 -0500
If you update a partitioned key, the row could move to another partition (if
row movement is allowed for the table, which was not the default behavior in
8i).
Jay
>>> Prasada.Gunda@xxxxxxxxxxxxxxxx 03/16/04 01:52PM >>>
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@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
-----------------------------------------------------------------
**DISCLAIMER
This e-mail message and any files transmitted with it are intended for the use
of the individual or entity to which they are addressed and may contain
information that is privileged, proprietary and confidential. If you are not
the intended recipient, you may not use, copy or disclose to anyone the message
or any information contained in the message. If you have received this
communication in error, please notify the sender and delete this e-mail
message. The contents do not represent the opinion of D&E except to the extent
that it relates to their official business.
----------------------------------------------------------------
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:
