david@smooth1.co.uk wrote:
> On 18 Oct, 16:29, "Ian Michael Gumby" <im_gu...@hotmail.com> wrote:
>
>> BTW, when will Oracle get their act together and do temp tables right?
>> Anyone who's had to suffer through their bastardized "global" temp tables
>> can appreciate that a *real* database allows users to create temp tables on
>> the fly as part of their adhoc queries.
>>
>> __________________________________________________ _______________
>
> How do Oracle temp tables work? What is the problem with them?
>

They are global, in that they are defined by someone with DBA
privileges, and the definitions are shared across all user sessions.
Different user sessions can then use them, and their specific data
extents are then local to that particular session, and can be temporary
(or can be persisted if required). So average joe blow user session
cannot create them.

There has always been some discussion about which approach is more
"correct". Obviously we at Oracle think this approach is better, for a
number of really good reasons. We could also do temp tables the same way
as informix and SQL Server, but have chosen to not implement them yet,
also for a number of good reasons. It does make migration from these
databases to Oracle a little problematic however