CODEWITHSUNDEEP
oracle-databaseoracle11g
Mike Christensen
Mike Christensen

Reputation: 91598

Is there a way to log every DELETE statement with Oracle?

I would like to log every DELETE statement in our database to a log file or table. Is there a way to do this?

I thought about creating a trigger on every table, but I cannot find a way to record the SQL statement itself within a trigger.

Does Oracle support logging certain database commands, and including the full command text within the logs? How does one enable this? Thanks!

Upvotes: 1

Views: 6819

Answers (1)

Gerrat
Gerrat

Reputation: 29690

Oracle does support this. You want to look at database Auditing

Upvotes: 3

Related Questions