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

Home -> Community -> Mailing Lists -> Oracle-L -> global temporary tables / on commit preserve rows

global temporary tables / on commit preserve rows

From: Foelz.Frank <Foelz.Frank_at_Scheidt-Bachmann.de>
Date: Thu, 12 May 2005 13:14:12 +0200
Message-ID: <184C07CA956B59418F925AACD4DF4CDE035B1F18@mail-server.iiv.scheidt-bachmann.de>


Hi all,

regarding Oracle 8x, 9x, 10x.....

If I have a global temporary table and I store data in it, commit it, = and
the the session drops due to what reason ever, what about the data that = had
been preserved in the table ?
Can it ever be deleted, or is it really neccessary, to drop and = recreate it
? Is there a possibility to figure out, how many rows of data are kept = in
this temp. table ?

thx

> Frank =D3=BF=D2 <

--
http://www.freelists.org/webpage/oracle-l
Received on Thu May 12 2005 - 07:19:27 CDT

Original text of this message

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