Truncate Notification

, ,
1

Hi

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

Thanks,

MT

2

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.

Mark