Anurag,

what version of oracle are you using. There is a bug in 8.1.5 that causes similar problems and has been fixed in 8.16 or 8.1.7

If you are using 8.1.5, try setting your temporary tablespace to permanent and try your query.

uday

[Edited by uday on 05-30-2001 at 01:59 PM]