The problem is that, we have more than one databases in different locations, but some of them are Oracle Standard edition, which does not permit (as I know, maybe I'm wrong) replication.
So we will create a synchronizing procedure, which will do the same thing.
Now if it's an insert or delete statement it's somehow easy, but in case of update we want to pass to the procedure only the modified columns, and the modified values. I've looked for some system views, but without any luck... So if you have ny idea it would be greatly appreciated...
Originally posted by alorincz ... some of them are Oracle Standard edition, which does not permit (as I know, maybe I'm wrong) replication.
The Basic Replication is supported by Standard Edition. You can create read-only snapshots on remote sites and let Oracle to replicate data automatically.
The Advanced (multi-master) Replication is part of EE only.
Ales The whole difference between a little boy and an adult man is the price of toys
We've created some audit table, and some linux functions that will do the work, but we need to find the modified columns, so that we won't have to synchronize all the columns in a table.
I was thinking, that it might be some Oracle system table / view from which we could find the modified columns. I'm looking in the Oracle documentation, but so far without too much luck...