Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Why Not Allow Temp Tables?
RE/
> Sounds like you've not understood what global temporary tables are about?
I think you've nailed it.
I was missing the "fixed structure, data-visible-to-only-inserting-session" part.
Now it makes more sense.
I'm taking the "no schema changes except under controlled cirumstances" part on faith. Would the prohibition be because letting somebody do a CEATE TABLE/DROP TABLE for temp tables mean that they could do the same thing with "real" tables?