juan wrote:
> On Jun 11, 5:56 pm, DA Morgan <damor...@psoug.org> wrote:
>> juan wrote:
>>> Good Afternoon,
>>> I am hoping someone can help me out. I want to drop a global
>>> temporary
>>> table in classic asp after my recordset has completed printing out
>>> it's rows.
>> By doing so you are defeating the entire point have having a global
>> temporary table. Do you understand what they are? In Oracle?
>>
>> The docs are at:http://tahiti.oracle.com
>>
>> If you need one ... you shouldn't be dropping it.
>> --
>> Daniel A. Morgan
>> University of Washington
>> damor...@x.washington.edu (replace x with u to respond)
>> Puget Sound Oracle Users Groupwww.psoug.org
>
> Daniel,
>
> I've tried to respond several times. I am hoping that one of these
> transmissions will go through.
>
> We are running the sql via a web application and once the data has
> been rendered, we wanted to administer clean up.

This may make sense in SQL Server or other Ingres based architectures
but it is bad practice in Oracle. You should not be building and
dropping objects in a session: Essentially ever.

I am really concerned that you don't understand what a GTT is. Have
you read the docs? Do you understand where they are built and how
they work? Do you understand that what you are trying to do is beat
the system to death while depriving the optimizer of the information
it need to do a good job?
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org