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: Wed, 20 Jun 2007 06:21:35 -0700
Message-ID: <1182345692.867312@bubbleator.drizzle.com>


Connor McDonald 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.
>>
>> I tried executing the following statement and I get the following
>> error:
>>
>> Drop Table tmm_a03_gtt_YYYJCO3_0611154125
>>
>> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>>
>> [Microsoft][ODBC driver for Oracle][Oracle]ORA-14452: attempt to
>> create, alter or drop an index on temporary table already in use
>>
>> FYI; We are using Oracle 10 g.
>>
>> Thanks,
>>
>> Juan
> 
> The way to clean up a GTT is:
> 
> "commit"

Unless it was created with ON COMMIT PRESERVE ROWS.

-- 
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 Wed Jun 20 2007 - 08:21:35 CDT

Original text of this message

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