Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Invalid Triggers

3042310Oct 1 2015 — edited Oct 1 2015

Hello!

We have an Oracle Database 11g Release and some days ago we found a problem with some data of a table because a trigger of the table wasn't executed due to being Invalid. There weren't any errors in the code of the trigger.

I have read that when the trigger is going to be executed, Oracle automatically notices that its status is Invalid and recompile it. So, I doubt why it didn't happen in our case, and if there is an automatic way to avoid this case.

I have found some ways like using "utlrp.sql" or "alter trigger....compile" but to do that we should create some jobs or include that code in every trigger or code. I wonder if there is any automatic code.

Thanks a lot!

Comments

damorgan
You can compress or not compress at the partition level. I am unclear as to the point of your inquiry.
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 29 2015
Added on Oct 1 2015
4 comments
2,407 views