Members   Search   Help    Register    Login   Home
Home » Server Options » Replication » impact of triggers on replication (oracle 10g)
impact of triggers on replication [message #428484] Wed, 28 October 2009 08:43 Go to next message
reachmala@gmail.com
Messages: 1
Registered: September 2009
Junior Member
HI,

I am using prebuilt MV to perform replication of about 300-400 master tables from one database to another database.

I am wondering about the impacts on triggers in general replication.

IS there a general rule to enable/diable a tigger before a refresh.

please provide your thougths on this.

Cheers,
Report message to a moderator
Re: impact of triggers on replication [message #428553 is a reply to message #428484] Wed, 28 October 2009 15:44 Go to previous message
gentlebabu
Messages: 1398
Registered: December 2005
Location: India, Hyderabad
Senior Member
Yes. Check

DBMS_MVIEW.I_AM_A_REFESH

- Babu
Report message to a moderator
Previous Topic:which soln is best for data propogation from master to app DB?
Next Topic:Data Propagation to MV site.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 30 14:57:55 CST 2009

Total time taken to generate the page: 0.31671 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.