Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Drop a Global Temporary Table using Classic ASP
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
![]() |
![]() |