RE: Deadlock on CDC_ALTER_CTABLE_BEFORE
Date: Mon, 15 Jun 2009 08:54:38 -0400
Message-ID: <6AFC12B9BFCDEA45B7274C534738067F1835F810_at_AAPQMAILBX02V.proque.st>
Hi Alan,
Take a deep breath....now let it out slowly. It's not the end of the world. If you have MetaLink access, see DOC ID 360509.1.
This appears to be a known problem w/ an easy fix.
-Mark
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Guillermo Alan Bort
Sent: Monday, June 15, 2009 8:15 AM
To: oracle-l-freelists
Subject: Deadlock on CDC_ALTER_CTABLE_BEFORE
After a newbie mistake I get a few errors from the data dictionary (dba_* views not working, synonyms brokent, etc). Obviously the data dictionary is broken. When I try to re-create it using catalog.sql I get these errors:
ERROR at line 1:
ORA-04020: deadlock detected while trying to lock object
SYS.CDC_ALTER_CTABLE_BEFORE
I opened the database in restricted mode.
Any ideas?
Alan Bort
Oracle Certified Professional
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jun 15 2009 - 07:54:38 CDT