Re: Temporary tables in Oracle

I think we all know how to create standard tables to be used temporarily, 'implicitly temporary' tables, but the point people are missing is that 'explicitly temporary' tables are typically more efficient (lightweight) than standard tables. An example of functionality provided by other RDBMSs, OpenIngres's temporary tables, in addition to being automagically removed at session end, are not cataloged, exist exclusively in memory (if possible) and are not logged (to the recovery log).

Oracle's 'non recoverable' table option seems like it could be a step in the right direction, but it is currently intended for a different purpose.

--
Scott Thompson




> > >

> > > But then he could create temporary tables the same way he did in

> > > Informix and then explicitly delete them when he was through with

> > > them.  I agree it isn't as neat a solution as Informix has, but

> > > adding "DROP TABLE temp;" at the appropriate time and place doesn't

> > > strike me as being too much of a hardship  :-)

>

> ... lines deleted ...

>

> i think the best solution is to create a 'permanent' table with the userid

> (or sessionid) as part of the key.

>