hi rohit

i have my own doubts as you said that temporary tables are created in temporary tablespace... but i feel only temporary segments get created in the temporary tablespace.

when i try to list out the colums from the views then the tablespace_name column is empty ..when i try to check out with dba_tables..

where does the temporary table get created .. is it in the swap area

regards,

sharmila