Oracle user defined Function based index and Ora-4020

From: David Fowler <dbf57_at_earthlink.net>
Date: Wed, 24 Jul 2002 03:45:19 GMT
Message-ID: <jpp%8.137$Ky3.16659@newsread2.prod.itd.earthlink.net>

I'm getting a ora-4020 deadlock detected on hpux 64 running oracle 8.1.7.4 single processor box.
The table had dependent trigger, stored procedures , views. I dropped all those.
I'm the only user on the instance.

Still getting this when attempting to create an index on a function that is determinastic returning upto a 30 varchar2.

The test case worked against a table built with create table new_tab as select * from the_table_im_Trying_to_index.

I built the function/ function index against this new table fine.

Any ideas?
thanks.
Dave Fowler Received on Tue Jul 23 2002 - 22:45:19 CDT