oracle enable row movement,row movement is not enabled

Dear 788042,

You need to enable the row movement option for an object when you need to shrink the space or for instance flashback the relevant object.

Here is an explanation from Thomas Kyte;

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:936216200346623192

+"+

+and we said...+

+allowing row movement is simply giving Oracle permission to modify a rows rowid.+

+In the beginning, a rowid was assigned to a row and was immutable. Starting in 8i, we allowed people to update a partition key in a partitioned table that would cause the row to move from partition A to partition B. In order to do that, we need to modify the rowid - but we had a documented implementation feature whereby a rowid was immutable. In order to permit this operation - we had to make it so that a DBA would consciously give us permission to do this.+

+So, row movement - needed for partition key modifications that move the row, needed for alter table t shrink space compact, needed for flashback table is just a "permission", it does not affect runtime performance at all+

+"+

I don't think there is an option or clause to enable the row movement for all tables in the database. PL/SQL block can handle this by executing multipte alter commands.

You do not have to touch the row movement option for a table after the operation. You can either disable or re-enable it as desired.

Regards.

Ogan