PROBLEM:
While analyzing the table for chained rows, got below error. ORA-1495
ANALYZE TABLE SCOTT.EMPTAB LIST CHAINED ROWS; * ORA-1495 specified chained row table not found
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;