If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

this is what I have so far. though I am getting errors. ORA-00947: not enough values, I think I understand that it means since I have two columns that I need another value. I am just not sure what to put there so that I can get the time and date the event occurred.

But what does it tell you? It is a statement level insert that tells you that someone deleted something from a table.
That doesn't seem very useful. If you want to audit deletes, then you should look at Oracle auditing.

Basically we have a mapping software that stores its information on the oracle database, and at the moment we only have one person doing the editing of the maps. But we have had things in the mapping software disappear so the company who made the mapping software told me to put some triggers in to monitor deletes. So with the one above and two others, I am hoping it will show me if the items are being deleted from the database or if there is something in the mapping software causing the issue. If that makes sense.