Truncate Notification


Is there a way to get notified on table truncate event?



Assuming you can create a database trigger that fires when a table is truncated in your DBMS, then yes. The trigger would just insert a row into a buffer table that you would monitor with a Basic Notification.

I believe Oracle 9i does not support this, but that Oracle 10g supports BEFORE / AFTER TRUNCATE triggers.

Perhaps one of our DBA members could comment.