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
