清除链接/迁移行

rem F:\oracle\ora92\rdbms\admin\utlchain.sql

spool on

analyze table employee
list chained row into chained;

rem create temp table
create table temp_chained
as select * from employee where rowid in (select head_rowid from chained_rows);

rem delete chained_rows
delete from employee where rowid in (select head_rowid from chained_rows);

rem insert those rows
insert into employee select * from temp_chained;
drop table temp_chained;

rem reanalyze the table
analyze table employee compute statistics;

 

select chain_cnt from user_tables where table_name='employee';

注：Oracle不会识别出具体式链接或者迁移行。。。