Bambang P wrote:

>
> My solution is by creating a table which holds record flag for the
> running trigger. The table should have a field TRANSACTION_ID for storing the
> CURRENT_TRANSACTION variable.
>

Remember that backup/restore with gbak resets the transaction
identifiers, so you can get unexpected results.


Regards,


Ann