Hi Sambhavan,

I checked the user and its default tablespace is called 'PROVISION' and the temporary tablespace is called "DRSYS'. And there is no tablespace called 'TEMP' in the instance at all. Also I am having this problem only from today noon.

This makes things all the more confusing for me.