Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Stale data visible on oracle index

NikJunejaAug 16 2019 — edited Aug 20 2019

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

Comments

Processing

Post Details

Added on Aug 16 2019
14 comments
1,756 views