Check row migration methods

Check the row migration method:
1) run $ ORACLE_HOME/rdbms/admin/utlchain. SQL
2) analyze table table_name list chained rows into chained_rows
3) Select * From chained_rows where table_name = 'table _ name ';
Clear method:
Method 1: Create Table table_name_tmp as select * From table_name where rowed in (select head_rowid from chained_rows );
Delete from table_name where rowed in (select head_rowid from chained_rows );
Insert into table_name select * From table_name_tmp;
Method 2: Create Table table_name_tmp select * From table_name;
Truncate table table_name
Insert into table_name select * From table_name_tmp
Method 3: Use the exp tool to export the table, delete the table, and use the IMP tool to import the table.
Method 4: alter table table_name move tablespace tablespace_name, and then re-index the table
The above four methods can be used to eliminate the existing row migration phenomenon. However, in many cases, the pct_free parameter is too small, so you need to adjust the value of pct_free.