Re: Drop a Global Temporary Table using Classic ASP

On Tue, 12 Jun 2007 13:48:28 -0700, juan <juan.oceguera_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