Bruce Momjian wrote:
>
> > In Oracle, temp tables occupy the same name space. One can not have two or more
> > users with the same temp table name without it being the same table. This is
> > why temp tables are not as used as one would think in Oracle.
> >
> > To use a temp table in Oracle you have to some up with some random naming
> > scheme. It really blows. Because of this Oracle developers have long stayed
> > away from temp tables.
>
> Wow, that really does stink. I know Informix can't have a temp table
> with the same name as a real table, and I thought that was bad, but
> Oracle is much worse.
>
Although....
One can see the advantage in a globally shared temporary table. For instance,
something like user web session management. One can insert and update against
the temp table and never have to worry about disk I/O or vacuuming. (Assuming a
temp table is implemented as a memory buffer)
--
42 was the answer, 49 was too soon.
------------------------
http://www.mohawksoft.com
