Re: ORA-01466 unable to read data - table definition has changed

Iain William Wiseman wrote:
> Hi folks,
>
> <<<
> ORA-01466: unable to read data - table definition has changed
> >>>
>
> I keep seeing this error on one particular box.
>
> When the error was originally found it was in a different query to the
> one above but the same error. Seeing this error the first time through I
> opted to copy the dbfs as it would take ages to re-install.
>
> So using the same binary with the same data on a different box does not
> produce the error.
>
> Any ideas?
>
> We are running on SunOs 5.9 on a sunfire and using oracle 9.2.0.4
>
> Thanks all,
> Iain
> New Zealand

Not really, as it could be any one or more of a number of reasons:

   Bad disk controller
   Bad media
   Memory issues
   Faulty cabling
   Faulty power supply

Any of the above issues could create the error you report. As this does not occur on another server, similarly configured, with the same release of Oracle it is clearly not a software problem. You need to examine the offending server and determine the root cause. Of course, you now have some possible areas in which to search.

Good luck on your endeavour.

David Fitzjarrell Received on Tue Jun 14 2005 - 21:03:31 CDT