Re: Will ROWID change during DB Runing??

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Fri, 31 Dec 2004 11:12:21 +0100
Message-ID: <41d5260a$0$24776$636a15ce@news.free.fr>

"Grant Zhou" <grantzhou_at_gmail.com> a écrit dans le message de news:cr341a$nl2_at_netnews.proxy.lucent.com...
| Is it true?
|
| With other articles, I learned that, the rowid will not change when physical
| address changes. When one row is moved to another block (row migration), the
| ROWID will still point to the orignal block, Oracle will keep the address to
| the other block in the orignal block.
|

My table guichets is partitioned by c_code_banque:

SQL> select rowid from guichets where c_code_banque=10008; ROWID

---

AAAB2kAADAAAF7+AAA

1 row selected.

SQL> update guichets set c_code_banque=30000 where c_code_banque=10008;

1 row updated.

SQL> select rowid from guichets where c_code_banque=30000; ROWID

---

AAAB2nAADAAAF8JAAA

1 row selected.

Regards
Michel Cadot Received on Fri Dec 31 2004 - 04:12:21 CST