Re: trigger question

  • From: Jim Dunleavy <jim.dunleavy@xxxxxx>
  • To: programmingblind@xxxxxxxxxxxxx
  • Date: Thu, 29 Jan 2009 16:44:46 +0000

Hi Georg,

I would use a trigger to do that.
A trigger can be disabled explicitly by the alter trigger command,
or by becoming invalid as a result of compilation errors.
I've also seen it happen after an import of a dump file created by a
full export.  I can't remember the exact details, but I think it was because
of some inter-dependency thing.
A trigger suddenly becoming disabled in a production database would be a
of something seriously wrong (database corruption, a rogue DBA?) and would
just as likely to happen to any other type of duplication mechanism
based on stored procedures.
If you need to investigate the cause of such strange events, you could
set up DDL triggers which would log the time and date, username, event type,
and object names of these events.  You could set the DDL trigger under
a more secure role than the role of the regular objects so as to minimize
the risk of the DDL trigger itself being disabled.



----- Original Message -----
From: Kellerer, Georg (LfU) <Georg.Kellerer@xxxxxxxxxxxxx>
To: <programmingblind@xxxxxxxxxxxxx>
Sent: Thursday, January 29, 2009 8:13 AM
Subject: trigger question

> Hi all,
> we are on to decide if we should use Triggers or stored procedures in
> our oracle database for data duplication. our problem now is that we
> don't know if it is possible to detect a disabled trigger at runtime. we
> are using an oracle 9i databse system and want to know when a trigger
> has not been fired and the copieng of the record was not successful. I
> know the all_triggers-Table where i can see the state of a trigger but
> isn't there a posibility to get an error-message when a speciffic
> trigger is disabled?
> thanks a lot for your help.
> greetings,
> Georg
> __________
> View the list's information and change your settings at

"Information in this email (including attachments) is confidential.  
It is intended for receipt and consideration only by the intended recipient.
If you are not an addressee or intended recipient, any use, dissemination,
distribution, disclosure, publication or copying of information contained in
this email is strictly prohibited.  Opinions expressed in this email may be
personal to the author and are not necessarily the opinions of the HSE.

If this email has been received by you in error we would be grateful if you 
could immediately notify the ICT Service Desk by telephone at +353 1 6352757 
or by email to service.desk@xxxxxxxxxxxx and thereafter delete this
e-mail from your system"
View the list's information and change your settings at

Other related posts:

  • » trigger question - Kellerer, Georg (LfU)
  • » Re: trigger question - Jim Dunleavy