ora-04020

From: Burton, Laura <BurtonL_at_frmaint.com>
Date: Thu, 15 Dec 2005 13:56:42 -0600
Message-ID: <B5E0B4818A669C49A9C22199D9C389F806B1D547@MAIL.frmaint.com>

I have a 9.2.0.7 Oracle database on MS Server 2003. I am getting the error above on anything I try to do. This is a newly created database. Also was able to import data from another database to it. Now everything gets this error. On Metalink it states to run the utlrp.sql script as sys. This did not correct the problem. I can query v$lock without getting an error, and I do not see a lock on the system. If I try to look at v$session I get

ERROR at line 1:

ORA-04020: deadlock detected while trying to lock object

SYS.CDC_ALTER_CTABLE_BEFORE Has anyone had a problem like this and was able to resolve it.

Thanks in advance,

Laura

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Dec 15 2005 - 13:56:59 CST