SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-25191: cannot reference overflow table of an index-organized table

SudhakarRJan 19 2014 — edited Jan 19 2014

Hi Team,

I'm receiving this error while collecting stats on IOT table as below and it was running properly till lastweek.

dbms_stats.gather_table_stats(ownname=>'DATASEG',method_opt=>'for all columns size 1', tabname=>'SYS_IOT_OVER_771974',cascade=>TRUE);

I can see the IOT_Name in dba_tables. could you please help me to get a solution for this error?

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 16 2014

Added on Jan 19 2014

13 comments

9,140 views