Re: Drop a Global Temporary Table using Classic ASP

On Jun 11, 5:56 pm, DA Morgan <damor..._at_psoug.org> wrote:
> juan wrote:
> > Good Afternoon,
>
> > I am hoping someone can help me out. I want to drop a global
> > temporary
> > table in classic asp after my recordset has completed printing out
> > it's rows.
>
> By doing so you are defeating the entire point have having a global
> temporary table. Do you understand what they are? In Oracle?
>
> The docs are at:http://tahiti.oracle.com
>
> If you need one ... you shouldn't be dropping it.
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

Daniel,

I've tried to respond several times. I am hoping that one of these transmissions will go through.

We are running the sql via a web application and once the data has been rendered, we wanted to administer clean up. On the web it's common practice to discard our objects (recordsets, connections, etc). It's my understanding that the data in GTT's is deleted once the session is done, but the schema will persist. These schemas will persist in the temp space...Is that correct?

What is the best practice in removing these unused GTT schemas?

Thank you in advance,

Juan

PS Please let me know if this should be addressed in a different group. Received on Tue Jun 12 2007 - 15:48:28 CDT