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
