ORA - 04098: the trigger 'SCOTT. DO_AUDIT_EMP_SALARY' is invalid and not through the revalidation
ORA - 06512: in line 12
04098. In 00000 - "trigger" % s. % s' is invalid and failed re - validation "
* Cause: A trigger was attempted to be retrieved for execution and the was
Found to be invalid. This also means that the compilation/authorization
Failed for the trigger.
* Action: Options are to resolve the compilation/authorization errors,
Disable the trigger, or drop the trigger.

CodePudding user response:

And a trigger conflicts to delete a trigger is good

CodePudding user response:

Find SCOTT. DO_AUDIT_EMP_SALARY this trigger, open compile once know where is wrong