Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: error during export 8.0.5
ORA-01466: unable to read data -- object definition has changed
Cause: This is a time-based read consistency error for a database object, such
as a table or index. Either of the following may have happened:
The query was parsed and executed with a snapshot older than the time the
object was changed.
The creation time-stamp of the object is greater than the current system time.
This happens, for example, when the system time is set to a time earlier than
the creation time of the object.
Action: If the cause is:
an old snapshot, then commit or rollback the transaction and resume work. a creation time-stamp in the future, ensure the system time is set correctly. If the object creation time-stamp is still greater than the system time, then export the object's data, drop the object, recreate the object so it has a new creation time-stamp, import the object's data, and resume work.
Paul in VT Received on Mon Aug 16 1999 - 12:17:58 CDT