Last updated on SEPTEMBER 14, 2011
Applies to:Oracle Server - Enterprise Edition - Version: 10.2.0.4 to 126.96.36.199 - Release: 10.2 to 11.2
Information in this document applies to any platform.
While these errors can all point to an issue in the database buffer cache, you may have tried to flush the buffer cache but the errors return.
SQL> alter system flush buffer_cache;
When analyzing/validating the affected table(s), you find an error (e.g. ORA-1498 or ORA-1499) reported during the analyze command indicating corruption.
SQL> analyze table <owner>.<table_name> validate structure cascade;
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms