Re: Will ROWID change during DB Runing??

From: Grant Zhou <grantzhou_at_gmail.com>
Date: Tue, 4 Jan 2005 09:47:49 +0800
Message-ID: <crcsgh$kr3@netnews.proxy.lucent.com>

oops, but the table is saved on the same table space and has no partition.

>
> 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 Mon Jan 03 2005 - 19:47:49 CST