Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> global temporary tables / on commit preserve rows
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-lReceived on Thu May 12 2005 - 07:19:27 CDT
![]() |
![]() |