RE: Temporary Tables

From: Gogala, Mladen <MGogala_at_allegientsystems.com>
Date: Fri, 26 Aug 2005 12:01:29 -0400
Message-ID: <D42C14B2E3F2B74DB41D5B6B2E2B992F019320BA@pegasus.lawaudit.com>

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_at_fishersci.com] 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
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Fri Aug 26 2005 - 11:03:08 CDT