Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: error during export 8.0.5

Re: error during export 8.0.5

From: PaulCinVT <paulcinvt_at_aol.com>
Date: 16 Aug 1999 17:17:58 GMT
Message-ID: <19990816131758.15205.00000497@ngol07.aol.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US