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

Home -> Community -> Mailing Lists -> Oracle-L -> ora-04020

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

Original text of this message

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