Hi All,

OK heres an interesting one....

I have an insert rule on a table. The rule is a statement level rule.

The table in question is prone to very large insert activity...so large that we blow our 5G log.

So we ran with set session with on_logfull = commit;

So if the statement fails for whatever reasaon after at least one logfile forced commit has occurred the rule never gets to activate...but I have committed activity on which I'd have very much liked it to activate!

Bugger!

Martin Bowes