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

> 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 Mon Feb 09 2004 - 18:07:17 CET