Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to Create Local Temporary Table

Re: How to Create Local Temporary Table

From: jackal <jackal_on_work_at_yahoo.com>
Date: 20 Apr 2006 01:32:52 -0700
Message-ID: <1145521972.954896.136040@z34g2000cwc.googlegroups.com> 





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
Received on Thu Apr 20 2006 - 03:32:52 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US