I have a Oracle 9i database table which is having before and after insert trigger. This table has to replicated to another database. Its a Master to Master Replication. My qestion is when the data is repliacted between the database is the trigger will be fired on the destination database table? Or what will be the efect on the destination database table which also have before and after insert trigger. Can any one help me on this issue. If it is going to effect in that case can we have transactional replication? What are the merits and demirits between master and transactional relplication...

Thanks in advance.