Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: how to drop a temp table

Re: how to drop a temp table

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 22 Nov 2000 21:16:00 -0000
Message-ID: <974924005.21678.0.nnrp-08.9e984b29@news.demon.co.uk>

There is a bug in 8.1 which leaves segments for 'proper' temporary tables locked. If you look in v$lock you will find a lock of type TT belonging to the app session which is now dead. I haven't been able to find a way to clear this lock yet, other than stopping and restarting the instance.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases

Publishers:  Addison-Wesley
Book bound date: 8th Dec 2000
See a first review at:
http://www.ixora.com.au/resources/index.htm#practical_8i
More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



futurshk_at_my-deja.com wrote in message <8vh7vi$562$1_at_nnrp1.deja.com>...

>I thought I had posted this, but seem to be able to find it, so I'm
>trying again, sorry if it comes up twice.
>
>Our application creates a temporary table, in Oracle 8, at startup and
>drops it at shutdown. A user shutdown the app improperly, causing the
>temporary table to not get dropped. I've tried to drop it using both
>the original user's logon and logged on as the DBA, but get the a
>response of
>'ORA-14452: attempt to create, alter or drop an index on temporary
>table already in use'.
>I checked through the Kill/Trace session in TOAD and the user is no
>longer has a session open.
>Any advice here would be great.
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Wed Nov 22 2000 - 15:16:00 CST

Original text of this message

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