PT - Row migration and Row Chaining

•  Row migration caused when no space is in the block for a row update
•  Row chaining caused by inserting a row larger than block size

Resolving Migrated Rows

• Export and Import Utilities
• Using ALTER TABLE MOVE command
• Online table redefinition
• Copy migrated rows

                                                                      Comparision

Correcting Row Migration by Increasing PCTFREE

Correcting Row Chaining by using Larger Block Size

Row Migration Using Online Redefinition

EXPDP | IMPDP - table_exists_action=tuncate  |  Or drop and recreate expdp | impdp