New answers tagged


UPDATE: What Worked... So after reading the link from @Raj and reading @ora-600's answer I tried to validate the database with the RMAN command backup check logical validate database;. While this worked fine, it was also clear that it was not looking at everything that the ANALYZE INDEX command would. After trying many different variations, I finally ...


You can try: shutdown immediate startup mount alter database datafile '/u02/oradata/hfd1/index/index17.dbf' offline drop; alter database open


I think the article Raj quoted ( describes this pretty well. "clustering factor" was also my first guess while reading the description of your problem. I also prefer to use RMAN to check for corruption. RMAN> backup check logical validate database; Afterwards you can query ...

Top 50 recent answers are included