can u all tell me whether an index become invalid if so under what circumstances.
Table was moved to another tablespace.
You recovered table which is NO LOGGING mode.
It's a global index and you dropped a partition on the base table.
"I pledge to stop eating sharks fin soup and will not do so under any circumstances."