So far the only thing I've found is to bounce the database.
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Practical Oracle 8i: Building Efficient Databases
Publishers: Addison Wesley Longman
Book bound date now 1st Dec 2000
Dmitry Rusakov wrote in message <8u0gms$1jbv$1_at_storm.comstar.ru>...
>I kill session, which use temporary table, defined as "on commit preserve
>rows". Session has data in this table. Table definition lock was't released
>by Oracle. What to do ?
>
>Sincerely
>D.Rusakov
>
>
Received on Sun Nov 05 2000 - 06:32:44 CST
