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: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 12 Jun 2007 19:08:31 -0700
Message-ID: <1181700509.859175@bubbleator.drizzle.com>


juan wrote:
> On Jun 11, 5:56 pm, DA Morgan <damor..._at_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..._at_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_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Tue Jun 12 2007 - 21:08:31 CDT

Original text of this message

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