Re: "All triggers are evil",..., really?

2008/9/3, Connor McDonald <mcdonald.connor_at_gmail.com>:
> I always find it hilarious when you have to wear the day-to-day hit of
> capturing changes to every row on every row due to some "cast hard in
> concrete business rule of - thou shalt audit everything" ....but then take a
> system outage because a large scale data change has to occur, and the same
> people then insert ..."but we don't want to audit that" comes along the
> line...

If audit triggers are disabled and data entered via scripts, then normally audit data should be collected via some scripts in one big chunk. Of course real life sometimes differ from "normally", for example, just because someone remebered to disable audit but forgot to add also audiot data :)

Gints Plivna
http://www.gplivna.eu

--
http://www.freelists.org/webpage/oracle-l