Re: Deadlock on CDC_ALTER_CTABLE_BEFORE
Date: Mon, 15 Jun 2009 15:42:40 +0300
- make a proper backup of current state of your DB B.
- restore your DB to the state just before you made your mistake if proper backups doesn't exist
- remember the case for the rest of your DBA life - try to export date -- by exp
if doesn't work
-- by sqlplus (select * from <tables>)
Just my 0.02$
On Mon, Jun 15, 2009 at 3:15 PM, Guillermo Alan
> 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
> I opened the database in restricted mode.
> Any ideas?
> Alan Bort
> Oracle Certified Professional
-- Jurijs +371 29268222 (+2 GMT) ============================================ http://otn.oracle.com/ocm/jvelikanovs.html -- http://www.freelists.org/webpage/oracle-lReceived on Mon Jun 15 2009 - 07:42:40 CDT