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: Howto Create global temporary table in Oracle 8.0.5

Re: Howto Create global temporary table in Oracle 8.0.5

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Thu, 15 Dec 2005 05:49:02 GMT
Message-Id: <pan.2005.12.15.05.49.02.777086@sbcglobal.net> 





On Wed, 14 Dec 2005 14:02:45 -0800, degelis wrote:



> However, How can I create a temporary table in Oracle 8.0




You must do it in two steps:


1) Upgrade your database from a relict to more contemporary version.


   Version 9.2 is considered conservative, 10gR2 would be good.
2) Create global temporary table.


-- 
http://www.mgogala.com


Received on Wed Dec 14 2005 - 23:49:02 CST












Original text of this message













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