I had autoextend option on that temp table space and had a temporary
storage type. I disabled autoextend and
bounced the database by using NT services. It did turned the database
quickly but database is still having 4G of temp tablespace. When
I tried to resize it, it is saying file contains used data beyond the
requested resize value error message.

Any further thoughts and suggestions.

SKM