global temporary tables / on commit preserve rows
- From: "Foelz.Frank" <Foelz.Frank@xxxxxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 12 May 2005 13:14:12 +0200
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 <
--
//www.freelists.org/webpage/oracle-l
Other related posts:
