Deletion or Dropping of log tables

Deletion or Dropping of log tables

  
Hi all

I need to create a trigger on the oslog_Screen_X tables, but since these are rotated every week and some are emptied, I need to know if, when dumping the table, the contents are deleted or the table is dropped and created in which case the triggers would be lost.
Hi Orlando,

To dump the log tables the truncate action is used, so it is alright to use triggers as long as they are not delete triggers. You might already know this, but if you do implement triggers in these tables you should watch out for performance impact of these triggers.

Cheers,
Tiago Simões