Hi Hrishy,

After running the second query i saw the tablespace was offline. Hence i onlined the tablespace and everything started working. If it is baffling how this tablespace was offline as it only has one datafile and I switched to online. Maybe this tablespace was offline all the way along. Anyway now the problem is sorted and thank you very much for your help!

Thanks again,
Chucks