AW: Deadlock on CDC_ALTER_CTABLE_BEFORE

From: <Jan-Hendrik.Boll_at_dataport.de>
Date: Mon, 15 Jun 2009 14:47:56 +0200
Message-ID: <0FCF70745FD57F4F8259112EC5E800A5015E91EB_at_WSCXPR18.fhhnet.stadt.hamburg.de>

Looks like this is a system trigger.
You could try to disable it by setting

_system_trig_enabled=false

Anyway i hope you have a backup :-)

Regards

-----Ursprüngliche Nachricht-----
Von: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] Im Auftrag von Jurijs Velikanovs Gesendet: Montag, 15. Juni 2009 14:43
An: cicciuxdba_at_gmail.com
Cc: oracle-l-freelists
Betreff: Re: Deadlock on CDC_ALTER_CTABLE_BEFORE

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


--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jun 15 2009 - 07:47:56 CDT