Deadlock on CDC_ALTER_CTABLE_BEFORE

From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Mon, 15 Jun 2009 09:15:01 -0300
Message-ID: <172762180906150515o2f55396ap362de5f88086d55_at_mail.gmail.com>

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:15:01 CDT