I use them a lot. They're not as convenient as SQL Server's temporary tables, mostly because they're permanent structures. You can use them as long as you don't attempt to truncate them. It can be nasty, with all those library latch waits......Of course, your temporary tablespace must be big enough. Given the prediction that MPP will kill SMP, that is not so big of a deal. -- Mladen Gogala Ext. 121 -----Original Message----- From: Aggarwal, Meenakshi [mailto:Meenakshi.Aggarwal@xxxxxxxxxxxxx] Sent: Friday, August 26, 2005 10:52 AM To: oracle-l Subject: Temporary Tables Does anybody know any reason of not using temporary tables in Oracle 9i. Thanks -- //www.freelists.org/webpage/oracle-l