| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> comp.databases.oracle -> 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 - 11:07:17 CST
 |
 |