RE: Temporary Tables

  • From: "Gogala, Mladen" <MGogala@xxxxxxxxxxxxxxxxxxxx>
  • To: "'Meenakshi.Aggarwal@xxxxxxxxxxxxx'" <Meenakshi.Aggarwal@xxxxxxxxxxxxx>, oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 26 Aug 2005 12:01:29 -0400

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

Other related posts: