Deadlock on CDC_ALTER_CTABLE_BEFORE
- From: Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>
- To: oracle-l-freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 15 Jun 2009 09:15:01 -0300
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
Other related posts: