This content has been marked as final. Show 6 replies
Yes its possible. You can use Multimaster replication.
This link might help you.
If you are planning to do it for large data set (A lot of tables with bulk dml) then use oracle streams.
I would like to perform replication for all the tables in the database. However, I would only like to replicate any DML changes done by certain database account.
Example, I have database account "appserveraccount", "batchjobaccount" in the database.Question: will batchjobaccount also make changes to tables rows that normally changed by appserveraccount?
Yes its possible. You can use Multimaster replication.could you show how you can filter changes based on user (not schema) in MMR?
I haven't done anything like that before. Probably you can find something in oracle docs where you can customize the Oracle internal triggers and packages to achieve you goal.
I haven't done anything like that before.And why do you recommend this?
Probably you can find something in oracle docs where you can customize the Oracle internal triggers and packages to achieve you goal.No. You cannot customize Oracle internal triggers starting from Oracle 8i, if I remember it correct.
That is why they called internal. You do not see them. They are pre-compiled (in C) and linked somewhere in Oracle binaries.
And I suppose Oracle will not support modified replication packages.