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