Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Why does a SELECT query needs REDO?
On Sat, 11 Feb 2006 06:35:58 +0000, Mladen Gogala wrote:
> 1 create global temporary table t_emp
> 2 on commit delete rows
> 3* as select * from emp
> SQL> /
After a short discussion with Jonathan Lewis, I must admit
that global temporary tables are a special case and that my
conclusions were mistaken.
-- http://www.mgogala.comReceived on Sat Feb 11 2006 - 21:14:59 CST