Re: HELP HELP : ORA04080: trigger 'LOG_ERRORS-TRIG' does not exist

Hi, guys,
thanz alot for the idea and suggestions. Anyway, I dropped the trigger and the table created. After that, db back to normal. B'cos i am not afford the db down time for more than 2 days. All users start complaints around the world.

I really appreciate ur guys help! thanz again!

Anyway, i start worried about my db now. The last messages appeals before I dropped the trigger and the table created is 0604: error occured at recursive level 1 and 6502: PL/SQL; numeric or value error : character string too small.

After i dropped the trigger and the table created which cos the error, some of my users unable to performs certain insert, delete or updating. But others user who having a same priviledge and role as the group before, have no problem before.

pls advice me, how to diagnose or check if my db got error. Pls.

Thanz.

regards,
tracy

folke.larsson_at_bredband.net (Folke Larsson) wrote in message news:<3747d6a8.0402090907.61cdeef6_at_posting.google.com>...
> > Hi, I really need help.
> >
> > I run this script and error message appeal as below:
> >
> > drop trigger log_errors_trig;
> > drop trigger log_errors_trig
> > ERROR at line 1:
> > ORA04080: trigger 'LOG_ERRORS-TRIG' does not exist
> >
 

> > /
>
>
> Hello Tracy Kim
>
> Are you giving the commamd SHOW ERRORS after every compile
> or invalidation?
>
> Have you checked if there are any invalid objects by:
>
> SELECT SUBSTR(OWNER,1,15), SUBSTR(OBJECT_NAME,1,25), OBJECT_TYPE, STATUS
> FROM DBA_OBJECTS
> WHERE STATUS = 'INVALID';
>
> or something like that.
>
>
> Regards
>
> Folke Larsson
Received on Tue Feb 10 2004 - 09:44:04 CET