Fix ORA-10636: ROW MOVEMENT is not enabled Table Shrink Command Failed

Error Description:
Table shrink command failed with following error.

SQL> alter table siebel.EIM_ACCNT_UT shrink space compact;
alter table siebel.EIM_ACCNT_UT shrink space compact
*
ERROR at line 1:
ORA-10636: ROW MOVEMENT is not enabled

Solution Description:
Segment Shrink command reclaims the unused space. The shrink command compact the segment and adjusts the high water mark. Segment shrink requires that the rows be moved to new locations. So, you should enable the row movement for the table.

Please find the example below.

SQL> alter table siebel.EIM_ACCNT_UT enable row movement;

Table altered.

SQL>  alter table siebel.EIM_ACCNT_UT shrink space compact;

Table altered.
SQL> alter table siebel.EIM_ACCNT_UT disable row movement;

Table altered.
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google