SOLVED

ORA-1495 :Specified Chained Row Table Not Found

Asked by OracleDba••13 views•oracle
1
2
3
ORA-1495 :Specified Chained Row Table Not Found

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

Solutions(1)

Accepted Solution
1
2
3
4
5
6
7
8
9
10
11
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;
OracleDba•

Post Your Solution