HI, thanks for the suggestion.

I recreated the temporary tablespace , and I am able to query
the views.

But still I have doubt.

why some views refered to this
temporary tablespace eventhough a temporary tablespace named 'TEMP'
is also existing??