RE: global temporary tables / on commit preserve rows
- From: "Gamble, Scott" <Scott.Gamble@xxxxxxxxxxxx>
- To: <Foelz.Frank@xxxxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 12 May 2005 08:39:53 -0500
If the session that put the data into the temporary table goes away the =
data goes away.
Not sure what you meant by deleting it. While the session is active it =
can delete data that it put into a temporary table but once the session =
is dropped there is no more data to delete.
You should not have to drop and recreate temporary tables for any reason =
other than perhaps changing their structure.
I am not aware of any way to tell how many rows are in the table other =
than using sql_Trace to see how many rows were inserted or perhaps =
instrumenting your code to record that somewhere.
Metalink Note:68098.1 is an overview of temporary tables if you have =
access to metalink.
Scott
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Foelz.Frank
Sent: Thursday, May 12, 2005 6:14 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: 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, =
=3D
and
the the session drops due to what reason ever, what about the data that =
=3D
had
been preserved in the table ?
Can it ever be deleted, or is it really neccessary, to drop and =3D
recreate it
? Is there a possibility to figure out, how many rows of data are kept =
=3D
in
this temp. table ?
thx
> Frank =3DD3=3DBF=3DD2 <
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts: