RE: Possibility of changing Rowid because of UPDATE operations
- From: "Justin Cave (DDBC)" <jcave@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 16 Mar 2004 13:03:15 -0700
The ROWID is certainly liable to change due to an UPDATE of an IOT. I can't
think of a reason Oracle would change the ROWID of a row in a normal table
because of an UPDATE, but Oracle certainly does not guarantee such a thing.
It's always possible that some new feature will come along and cause ROWID's to
change because of an update-- I would avoid designing a system that depended on
hoping that didn't happen.
Have you looked into Oracle Change Data Capture (CDC)? It sounds like that's
what you're after here. If so, it's a lot easier to use Oracle built-in
functionality that to write it yourself.
Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Prasada.Gunda@xxxxxxxxxxxxxxxx
Sent: Tuesday, March 16, 2004 11:53 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Possibility of changing Rowid because of UPDATE operations
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
-----------------------------------------------------------------
----------------------------------------------------------------
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:
