ORA-04098: trigger 'APPS.LOGON_TRIG' is invalid and failed re-validation
Hello Dear All,
i am getting this following error in my alert log file of 11i applications database.
"ORA-04098: trigger 'APPS.LOGON_TRIG' is invalid and failed re-validation"
According to the Metalink (ORA-04098 Trigger '%s' Is Invalid and Failed Re-validation [ID 1035837.6])..
I recompiled
SQL> alter trigger logon_trig compile;
Warning: Trigger altered with compilation errors.
It compiled with Error
SQL> show errors trigger logon_trig;
Errors for TRIGGER LOGON_TRIG:
LINE/COL ERROR
-------- -----------------------------------------------------------------
2/1 PL/SQL: SQL Statement ignored
2/13 PL/SQL: ORA-00942: table or view does not exist
Here is my dought..
From the above result there is a table is missed from the compiled trigger was dropped. is it so,, then i have to run CATALOG and CATPROG to recreate all the default trigger and view.
Ok fine,, i suppose to run those scripts, but my drought is.. my Application have lot of customization updates day by day, and some users creates Triggers and all,,
If i run Catprog it will recreate the default "TRIGGERS". then what will happen to the user created TRIGGERS.. it will be there or not !
Kindly help me
:cool:
Table missing .. its belongs to APPS schema
its a Missing Table,, which is taking some value from "LOGON_TRIG" Trigger...
here am going to Post the Trigger:
DROP TRIGGER APPS.LOGON_TRIG;
CREATE OR REPLACE TRIGGER APPS.logon_trig
AFTER LOGON ON SCHEMA
BEGIN
INSERT INTO log_trig_table(user_id, log_date, action)
VALUES (USER, SYSDATE, 'Logging on');
END;
/
This Trigger Belongs to APPS schema.
I highlighted the Trigger affecting table,, that table is missing i hope,,
now if am running catprog.sql it may create those table, but if i ran that,, it will affect other triggers which created by my developers..(COUSTOM TRIGGERS)..