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

Hello Tracy,

  Any DDL (like "create") would perform commit internally before and after DDL ix executed - I.e. you can not rollback DDL.

 Looks like you run the script as user 'SYSTEM'. As a "sys" user issue "grant select on v_$session to system;" This would resolve issue of "ORA-00942: table or view does not exist".

Please, let us know if this helps.

Regards,

Support

DBA Infopower

https://www.dbainfopower.com

The advice provided by DBA Infopower are provided "as is" with no warranty. DBA Infopower expressly disclaims any warranty, regarding the advice including any implied warranty of merchant fitness for a particular purpose aviating course of dealing and/or performance. DBA Infopower does not warrant that the advices provided by DBA Infopower will be free from bias, detests, errors, eavesdropping or listening. DBA Infopower shall not be responsible for the quality of information or the authentication of the services or details given by experts on the advice. By using this advice the user of the advice accepts the terms and conditions of this statement.

"tracy" <tracykim10_at_yahoo.com.hk> wrote in message news:5c91cce9.0402060057.3d6ca551_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
>
> drop table log_errors_tab;
> drop table log_errors_tab
> ERROR at line 1:
> ORA00942: table or view does not exist
>
>
> create table log_errors_tab (
> error varchar2(30),
> timestamp date,
> username varchar2(30),
> osuser varchar2(30),
> machine varchar2(64),
> process varchar2(8),
> program varchar2(48));
>
> create or replace trigger log_errors_trig
> after servererror on database
> declare
> var_user varchar2(30);
> var_osuser varchar2(30);
> var_machine varchar2(64);
> var_process varchar2(8);
> var_program varchar2(48);
> begin
> select username, osuser, machine, process, program
> into var_user, var_osuser, var_machine, var_process, var_program
> from sys.v_$session
> where audsid = userenv('sessionid');
>
> insert into log_errors_tab
> values(dbms_standard.server_error(1),sysdate,var_user,
> var_osuser,var_machine,var_process,var_program);
> end;
> /
> WARINING: trigger created with compilation errors.
>
> SQL>roll back;
> Rollback complete.
>
> After that i got error message in my SQL:
> ERROR at line 1:
> ORA-04098: trigger 'SYSTEM.LOG_ERRORS_TRIG' is invalid and failed
> re-validation
>
>
> I check under user_objects & user_errors, result as below:
> 1 select * from user_objects
> 2* WHERE STATUS <>'VALID'
> SQL> /
>
> OBJECT_NAME
> --------------------------------------------------------------------------