ORA-1495 :Specified Chained Row Table Not Found

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • User AvatarKiran Dalvi
  • 14 Dec, 2023
  • 0 Comments
  • 1 Min Read

ORA-1495 :Specified Chained Row Table Not Found

While analyzing the table for chained rows, got below error. ORA-1495

SOLUTION:

To fix it run the utlchain.sql script.
 
sqlplus / as sysdba
$ORACLE_HOME/rdbms/admin/utlchain.sql script
After that
 TRUNCATE TABLE CHAINED_ROWS;
ANALYZE TABLE SCOTT.EMPTAB LIST CHAINED ROWS;