Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ROW MIGRATION

dbakelyJun 7 2004 — edited Jun 7 2004
Hi,
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 5 2004
Added on Jun 7 2004
6 comments
317 views