What you need to do is read the Oracle documentation on how it uses temporary tablespaces -- it changed in 8i.

Search the forum for previous questions on temp tablespaces being full, 'cos this gets asked about once a month.