Re: Need help!!!

On Jun 26, 11:03 am, siva.thirumai...@xxxxxxxxx wrote:
Hi,

Can some one tell me how can I disable a trigger when it is being
called?

Please find the details about the setup:

I have create a trigger T1 for the table TAB1 in the schema A in the
database D1 and similarly I have create a trigger T2 for the table
TAB2 in the schema B in the database D2.

This setup was done inorder to update any transaction that happens
locally say TAB1 in the remote database table TAB2.

I have create the procedures to update the transaction in the other
database.

However, while testing, I tried to insert/update manually, I am
getting the error like primary key constraint voilated.

Hence I disable the trigger at the remote database and tried to
update/insert. It worked fine.

There are no problem with delete even when both the triggers are
enabled.

Hence in order to automatically disable the trigger in the remote
database when it is receiving some updates from the local database. It
should get disabled and once the update is done. it should get
enabled.

This disabling and enabling should occur only when it is coming from
the other database. If anything happens locally, this process should
occur. It should go in a normal manner.

Please provide me some solution for this or let me know how to disable
the trigger when it is being fired and starts executing the
procedures.

Thanks in Advance!!!

Which release of Oracle are you using, and if it's 9.2.0.x, 10.1.0.x
or 10.2.0.x why are you not using Streams to perform this function?
The way you suggest to 'manage' this has 'mess' written all over it.

And posting the same message twice is not the way to get a response,
it's the way to get your posts ignored.



David Fitzjarrell

.

Relevant Pages

  • AFTER INSERT trigger
    ... How this trigger should be fired if I insert for example 400-500 records? ... remote database and I need a trigger to propagate these values to some ... database tables from the bridge table. ...
    (microsoft.public.sqlserver.programming)
  • Need help!!!
    ... I have create a trigger T1 for the table TAB1 in the schema A in the ... TAB2 in the schema B in the database D2. ... This setup was done inorder to update any transaction that happens ... This disabling and enabling should occur only when it is coming from ...
    (comp.databases.oracle.server)
  • Need help!!!
    ... I have create a trigger T1 for the table TAB1 in the schema A in the ... TAB2 in the schema B in the database D2. ... This setup was done inorder to update any transaction that happens ... This disabling and enabling should occur only when it is coming from ...
    (comp.databases.oracle.server)
  • Re: FreeBSD unstable on Dell 1750 using SMP?
    ... The problems I was experiencing were on a dual Xeon with HTT enabled as well. ... Perhaps someone out there who knows much more about the inner workings of FreeBSD may have an idea of why running top in "aggressive mode" like this might trigger the random rebooting. ... In any case, I'm anxious to try it out myself on our server to see if "top -s0" brings it down "on command" with HTT enabled, and not with HTT disabled. ... disabling HTT as I've done seems like a reasonable precaution to improve the stability.. ...
    (freebsd-stable)
  • Re: Disabling triggers
    ... Use the ALTER TABLE DISABLE TRIGGER ... Books Online for SQL Server SP3 at ... "Phil Davy" wrote in message ... > disabling it. ...
    (microsoft.public.sqlserver.programming)