- 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 scriptAfter that
TRUNCATE TABLE CHAINED_ROWS; ANALYZE TABLE SCOTT.EMPTAB LIST CHAINED ROWS;