Re: ora-04045 when using DML commands

In article <ONLr8.15791$4L4.571540_at_typhoon.austin.rr.com>, "Alvaro says...
>
>
>Fellow Oracle Netters:
>
>I have a SUN system running Oracle 9.0.1.1 Server.
>
>Previously, it was able to process any DML commands.
>Something got changed, and now each time that I attempt a DML command,
>it comes with:
>
>"ORA-04045: errors during recompilation/revalidation of
>SYS.CDC_ALTER_CTABLE_BEFORE"
>
>Any suggestions on where to begin to tackle this problem
>will be greatly appreciated.
>
>Thanks.
>
>A. Fuentes
>afuentes_at_goodpremises.com
>512-297-9937
>

that trigger is part of the Change Data Capture (CDC) processing.

They can go "bad" if someone removes Java from the database (rmjvm)

As SYS you can:

 DROP TRIGGER SYS.cdc_alter_ctable_before; 
 DROP TRIGGER SYS.cdc_create_ctable_after; 
 DROP TRIGGER SYS.cdc_create_ctable_before; 
 DROP TRIGGER SYS.cdc_drop_ctable_before;

if you have just removed the java stuff with rmjvm.

Change Data Capture is installed if you install Java -- but is not (yet) removed when you remove it. It is in a later release (due to the above)

If you have not run the rmjvm (java still exists in your database), please contact support for debugging this one.

>
>
>

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp