ROW MIGRATION
dbakelyJun 7 2004 — edited Jun 7 2004Hi,
I want to eliminate a row migration and row chaining in my table but an error occur when a list a chained rows. My script is like this
SQL> connect sys/change_on_install@kintana as sysdba
Connected.
SQL> analyze table rran.lots_de_travail1 compute statistics;
Table analyzed.
SQL> select num_rows, chain_cnt from dba_tables where table_name = 'LOTS_DE_TRAVAIL1';
NUM_ROWS CHAIN_CNT
---------- ----------
868050 238
SQL> analyze table rran.LOTS_DE_TRAVAIL1 list chained rows;
analyze table rran.LOTS_DE_TRAVAIL1 list chained rows
*
ERROR at line 1:
ORA-01495: specified chain row table not found
How to fix this error.
Regards.