Hi All,
Oracle version
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for IBM/AIX RISC System/6000: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
We have a strange situation in our Oracle production DB, where we are getting data from index, but table doesn't have any records for those values.
I know it sounds a bit weird, but when i query only indexed columns i get results but not when i query the entire row.
Is there any known bug with Oracle? And what should be our best solution, rebuild or drop and recreate index?
We also want to find the root cause what caused it.
Regards,
Nik