Skip to Main Content
Forums

SQL & PL/SQL

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!

How to check that trigger is fired or not?

593281Nov 28 2008 — edited Nov 28 2008
Hello All,

GoodDay, Hope all you are doing good.

I have created a trigger on one Materialized View(MV1), which will needs to capture the data when ever any DML operation is performed on Materialized View.

The Materialized View is refreshing successfully, but I am not able find any data on my audit table(which is used to store the data when the trigger is fired).

There might be one situation like, no new/updated data at source. But my question is, The trigger is firing or not? If so, how we can check that the trigger is fired on so and so Date/Time?


Please let me know how can I check..ASAP.


Thanks & Regards,
Ramesh.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 26 2008
Added on Nov 28 2008
#trigger
13 comments
9,315 views