Re: Understanding partitioning by hash

"Luc Gyselinck" <Luc.Gyselinck_at_nospampandora.be> wrote:

Excellent explanation. I think I got it.

>Now, what if you update the partitioning key? If you are lucky, the hash
>value of the new partitioning key is the same as the hash value of the old
>partitioning key, and the row will stay in the same partition. If NOT, the
>row will be moved to another partition if and only if you specified ENABLEd
>ROW MOVEMENT in the CREATE statement of the table, or if you forgot, you can
>do an ALTER TABLE <table> ENABLE ROW MOVEMENT. If no ROW MOVEMENT is
>enabled, you will receive an ORA- error, in the case the row should be
>moved.

So this is a "gotcha". A assume that enabling row movement has a price that has to be paid for, otherwise it would be always be enabled by default.

The only thing that remains to be cleared is whether partitioned indexes should be local or global, still working on that (pros and cons)

Thanks again.

Rick Denoire Received on Wed Oct 08 2003 - 17:59:18 CDT