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

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

Iain William Wiseman <iwiseman@eservglobal.com> wrote in
news:d8nilb$7l8$1@lust.ihug.co.nz:

> 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?
>

01466, 00000, "unable to read data - table definition has changed"
// *Cause: Query parsed after tbl (or index) change, and executed
// w/old snapshot
// *Action: commit (or rollback) transaction, and re-execute