Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Drop a Global Temporary Table using Classic ASP
On Jun 12, 9:07 pm, Galen Boyer <galen_bo..._at_yahoo.com> wrote:
> On Tue, 12 Jun 2007, juan.ocegu..._at_nav-international.com wrote:
> > We are running the sql via a web application and once the data has
> > been rendered, we wanted to administer clean up.
>
> This is a good thing.
>
> > On the web it's common practice to discard our objects (recordsets,
> > connections, etc).
>
> Yes, the objects you mention are good to clean up.
>
> > 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?
>
> You are thinking of #tmps. In SQLServer or Sybase, you shouldn't clean
> them out either. For these vendors, you should create them at the
> beginning of the life of the connection in the pool. Your cleanup step
> should delete the data out of them, but not drop them.
>
> An Oracle GTT exists as a single table for all connections. Treat it
> just like all other tables. Create it with the chunk of ddl scripts
> that are used to create all the persistent tables. The data either goes
> away on commit or stays around on commit based on your creation
> statement. Your cleanup step for these should be an issuance of a
> commit on the connection in the pool.
>
> --
> Galen Boyer
Thanks Galen. Received on Wed Jun 13 2007 - 09:29:17 CDT