hi Amar,
I have dropped and recreated the database and imported the latest dump taken at around 5.00 in the evening. Now the database is up and running.

Thanks for the the support at the right time.

Thanks & regards,
Ramesh