Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Re: HELP HELP : ORA04080: trigger 'LOG_ERRORS-TRIG' does not exist

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

From: Folke Larsson <folke.larsson_at_bredband.net>
Date: 9 Feb 2004 09:07:17 -0800
Message-ID: <3747d6a8.0402090907.61cdeef6@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 Mon Feb 09 2004 - 11:07:17 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US