Well, my general usage for triggers (and I use a few of them)is to
implement an action ( trigger code) based upon an event on my table
(we're talking table triggers now). For instance, I have multiple tables
that are updated during the online day and I want to capture specific
information (data) when a row or rows or column or columns have changed
in these tables. Depending on the type of change I'll insert some data
via the trigger code to other tables. This is one simple scenario.
However, if I want to replicate data or transfer data to another schema,
I use Oracle Streams. It's just cleaner for me that way, because I'm not
tied up with grants/access/synonyms, etc. from one schema to another
within the same database and if I wanted to move these schemas to
another database or server separate from each other, it's easier for me
to manage with Oracle Streams.
As a DBA, I do not discourage the use of triggers but rather encourage
the use of a "tool or feature" for what it best suited at doing. I let
my Business Rules and the resources at my disposal dictate to me what's
the best approach and I ALWAYS TEST, TEST, TEST and then choose the most
efficient, scalable, managable and best performing solution at hand.
Regards Jim
Chuckles Note: We're talking Oracle here and it always depends is the
standard answer
-----Original Message-----
From: MurliB826
[mailto:oracledba-ezmlmshield-x66481272.[Email address protected]
Sent: Wednesday, December 29, 2004 6:35 PM
To: LazyDBA Discussion
Subject: Triggers
My manager wants to discourage the use of triggers for populating data
across
different schema in the same server and the use of cascading triggers.
Could
someone tell me in what instances or circumstances would be best to use
triggers? If data consistency is one of the best usages of triggers,
please give me
an example.
Thanks,
Michael
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page