Cry
about...
Oracle Troubleshooting
ORA-01466: unable to read data - table
definition has changed
Symptom:
The error (possibly during an export):
ORA-01466: unable to read data
- table definition has changed
Cause:
Oracle has detected a problem when trying
to read the database table (or index). The creation
timestamp of the table (or index) is in the future.
Possible remedies:
According to Oracle this could be
caused by a long running snapshot. Try committing
or rolling-back all outstanding transactions and
try again.
The system time has been changed.
Oracle suggest exporting the affected tables,
dropping the tables and importing them.
If this error is encountered when
trying to export tables then try exporting the
tables without the flag 'consistent=Y'.
|