Problem with alter table move
Hi,
I have a strange problem. Normally I rebuild all the indexes that becomes invalid after 'alter table tablename move' command. Then the indexes again become valid. But since last couple of days some particular indexes have been becoming invalid after getting rebuilt and staying valid for some time after the rebuild. Please share your ideas about the incident.
Thanks in advance.
Problem with alter table move
I am not clear with the point "a second maintenance job was started after index reorganization got complete". Could you please elaborate it please?
Problem with alter table move
Got it sir :) . i will monitor if any other process is the culprit and will let you know.