AW: Deadlock on CDC_ALTER_CTABLE_BEFORE

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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] Im 
Auftrag von Jurijs Velikanovs
Gesendet: Montag, 15. Juni 2009 14:43
An: cicciuxdba@xxxxxxxxx
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@xxxxxxxxx> 
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

Other related posts: