Seema, I use Global Temporary Tables all the time. They are memory structures. Very fast. Very easy to set up. No problems at all. Good Luck Tom Mercadante Oracle Certified Professional -----Original Message----- From: Seema Singh [mailto:oracledbam@xxxxxxxxxxx] Sent: Wednesday, October 27, 2004 1:34 PM To: oracle-l@xxxxxxxxxxxxx Subject: TEMPORARY TABLE Hi, Is any performance problem if we go with TEMPORARY table? any thoughtS? thx _________________________________________________________________ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l