SQL> begin
dbms_stats.gather_table_stats(ownname => ‘EXFSYS’, tabname => ‘RLM$ERRCODE’, estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE, method_opt => ‘FOR ALL COLUMNS SIZE AUTO’, cascade =>TRUE,degree=>12, no_invalidate=>false);
end;
ORA-25191: cannot reference overflow table of an index-organized table
SOLUTION:
SQL> select IOT_NAME from dba_tables where owner=’EXFSYS’ and table_name = ‘SYS_IOT_OVER_70459’;
IOT_NAME
RLM$ERRCODE
SQL> begin
dbms_stats.gather_table_stats(ownname => ‘EXFSYS’, tabname => ‘RLM$ERRCODE‘, estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE, method_opt => ‘FOR ALL COLUMNS SIZE AUTO’, cascade =>TRUE,degree=>12, no_invalidate=>false);
end;
PL/SQL procedure successfully completed
done…