Thanks for ur dedicating the time and patience to reply my problem, but I cannot provide the info u had requested since I had replaced the database with the lastest dump and before doing this I backed up the database with was having this table problem after which I import this corrupted data in another machine to find that the corrupted table had no longer any rows and all operations were able to be done on it. I had no time to explore the possibilities of the problem cos it affected the live transactions!!!!!!!!!
Once again thanx all.

Rgds,
Sudhakar