14 Replies Latest reply: Jun 8, 2010 6:32 AM by 618702 RSS

    ORA-1410 no index involved

    MaJo
      Hello

      A select * from table order by 1 stops and returns ORA-1410. No indexes are accessed

      Doing:
      SQL> analyze table ap2dw.ist_perfaggr_r_7 validate structure cascade;
      analyze table ap2dw.ist_perfaggr_r_7 validate structure cascade
      *
      ERROR at line 1:
      ORA-01410: invalid ROWID

      What are the steps to analyze this further ?
      I'm aware that unusable indexes can cause this but we do not access any indexes.
      The table is truncated and reloaded every night

      Appreciate your comments..

      Regards
      Magnus