Is there a way to avoid ORA-01502: index or partition of such index is in unusable state when deleting data? I mean even when index is used to check uniqueness then during deletions there is no way of creating dupes anyway... To put in other words: is the only valid option to drop an index and recreate it, even for DELETE statement?
Thank you