Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to Create Local Temporary Table
jackal wrote:
> Hi,
>
> But isnt that a good functionality? All these temp tables in SQL server
> are created in the tempdb database and you can place the tempdb
> datafiles in a different disk altogether. I too many times have to
> create temp tables in Oracle, to aid in reporting purposes. But those
> are temporary with respect to the other normalized ones, slightly out
> of the league.
>
> Why do the faculties advice not to create temp tables in Oracle. Please
> elaborate on this.
>
> Regards
> Jackal
Global temporary tables in Oracle use a temp tablespace, which sounds similar. Received on Thu Apr 20 2006 - 08:37:08 CDT