|
|
| Re: In one way stream replication, do i need to disable function,trigger and proc on destination [message #361641 is a reply to message #355877] |
Thu, 27 November 2008 04:13  |
gb74it
Messages: 3
Registered: November 2008
|
Junior Member |
|
|
Hi,
using stream, triggers don't fire if the dml operation is executed by an apply process.
So in your replicated site the triggers will not fire, unless the dml is local in the replicated site (e not from the source site).
This id due to the fact that the triggers are created by default with the property fire_once to false.
You can set this property to true, but in this case the triggers will fire also in teh replicated site, also for dml originating from the other site.
Yuo can use this command to set the property to true:
exec dbms_ddl.set_trigger_firing_property (trigger_owner,trigger_name, TRUE);
You can use this command to show the property:
BEGIN
IF dbms_ddl.is_trigger_fire_once(trigger_owner, trigger_name) THEN
dbms_output.put_line('TRUE');
ELSE
dbms_output.put_line('FALSE');
END IF;
END;
/
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
