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: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 20 Jun 2007 20:59:41 +0800
Message-ID: <467924BD.45C8@yahoo.com>


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"

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------
Received on Wed Jun 20 2007 - 07:59:41 CDT

Original text of this message

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