Oracle DBA, How To, Error, Cause and Action

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

ORA-01466: 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