Re: Deadlock on CDC_ALTER_CTABLE_BEFORE

From: Jurijs Velikanovs <j.velikanovs_at_gmail.com>
Date: Mon, 15 Jun 2009 15:42:40 +0300
Message-ID: <d6f0def50906150542s72e13b04tbfe3431ae7525c09_at_mail.gmail.com>

A.
- 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$
Y.

On Mon, Jun 15, 2009 at 3:15 PM, Guillermo Alan Bort<cicciuxdba_at_gmail.com> wrote:
> 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
>

-- 
Jurijs
+371 29268222 (+2 GMT)
============================================
http://otn.oracle.com/ocm/jvelikanovs.html
--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jun 15 2009 - 07:42:40 CDT