I should have been little specific about the version I'm talking. Iam talking about LMTs on 8i.

I had little weird experience on creating TEMP tablespace as LMT... I can't see that tablespace in the list when I query dba-tablespaces view...

9i LMTs support all types of tablespaces... as SANJAY say. I'm not sure about the oracle version you are talking about ..

This error is not going to harm your database anyway, if it can't extend TEMP tablespace. Probably your query will not come back OR if someone trying run a complex query this error might get repeated. You don't need to be panic...