Thursday, August 6, 2020

OGG-01004, OCI Error ORA-04098: trigger 'MEIS.ZONE_TG' is invalid and failed re-validation (status = 4098)

OGG-01004, OCI Error ORA-04098: trigger 'MEIS.ZONE_TG' is invalid and failed re-validation (status = 4098)

Cause:

Triggers are causing issue while data is being loaded to table.



Resolution:

You could use the option “SUPRESSTRIGGERS” in the Replicat processes. 
If it still abends the Replicat process, 
you may have to disable the trigger in the database and restart the process.

sql> alter trigger ‘<User>.<Trigger>’ disable;

Ex:

SQL> alter trigger MEIS.ZONE_TG disable;

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

ALCATEL 6900

write memory copy running certified reload from working no rollback-timeout