RE: global temporary tables / on commit preserve rows

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Foelz.Frank Sent: Thursday, May 12, 2005 6:14 AM
To: oracle-l_at_freelists.org
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 <

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l