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!

Setup a Email trigger with specific Oracle table

User_MH06LNov 21 2018 — edited Nov 22 2018

Hi,

I Have a table called TEST_TABLE. I need to get an email alert, if any changes happened in this table (like insert,update,delete & drop).

I Have few options in my mind, using DB trigger or DB Auditing.

I Have created the DB Auditing but I dont know how to schedule the email alert with this option?

Coming to Trigger, I dont know how to write trigger sql with this option.

so can anyone please help how to get the email alert if any changes happened in this table?

Added on Nov 21 2018

#general-database-discussions

11 comments

9,040 views