ORA-1495 :Specified Chained Row Table Not Found - Learnomate Technologies

ANKUSH THAVALI
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;