Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Drop a Global Temporary Table using Classic ASP

Re: Drop a Global Temporary Table using Classic ASP

From: juan <juan.oceguera_at_nav-international.com>
Date: Wed, 13 Jun 2007 07:29:17 -0700
Message-ID: <1181744957.837331.137940@n15g2000prd.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US