webMethods

webMethods

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Back to discussions
Expand all | Collapse all

Truncate Notification

  • 1.  Truncate Notification

    Posted Mon February 13, 2006 06:05 PM

    Hi

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

    Thanks,

    MT


    #Adapters-and-E-Standards
    #webMethods
    #Integration-Server-and-ESB


  • 2.  RE: Truncate Notification

    Posted Mon February 13, 2006 06:28 PM

    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


    #webMethods
    #Integration-Server-and-ESB
    #Adapters-and-E-Standards


Related Content