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:51:11 -0700
Message-ID: <1181746271.767020.5770@q19g2000prn.googlegroups.com>


On Jun 12, 4:01 pm, sybra..._at_hccnet.nl wrote:
> On Tue, 12 Jun 2007 13:48:28 -0700, juan
>
> <juan.ocegu..._at_nav-international.com> wrote:
> >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?
>
> Not correct. The *table* will persist. Please do not confuse a table
> with a schema
>
>
>
> >What is the best practice in removing these unused GTT schemas?
>
> Tie your arms behind your back to avoid you are wasting your time in
> dropping them.
>
>
>
> >Thank you in advance,
>
> --
> Sybrand Bakker
> Senior Oracle DBA

Thanks for taking time to respond. Received on Wed Jun 13 2007 - 09:51:11 CDT

Original text of this message

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