Update on Key Fields in partitioned Table

[SamC]

Hello,

sorry for the beginner question.

My problem, i have a partitioned table. The Key Fields are somthing like FieldA and FieldB. Data is stored all went fine.

Some time later i have to update the date of the key fields, cause i found an error i made while calculating the values of this key fields. Is there a method to get oracle to implicitly move the data to the new partition by just updating the data?

Any hint would be nice.

Sam

 

[stefanhei]

Hi
You have to enable it first:

ALTER yourTable ENABLE ROW MOVEMENT

 

[SamC]

Thanks Stefan,

just tested. Worked fine.

Sam