I'm using datapump to keep 2 databases in sync. When exporting data with expdp the query-parameter is used to filter data from the tables - not all data need to be synced all the time.
Now I'm wondering if there is any way to log the number of exported records within the database in some kind of log table. Or to set some flag on every record touched by expdp. How could I achieve any of these?
I had a look now at Streams and Change Data Capture ... and this made me thinking, if creating a database link between those databases wouldn't be an option after all. Previously I planned to send files over ssh - which does creat some overhead. But if i manage to setup a database link through ssh ... this would make data exchange so much easier. And then I even might be using the features you proposed ...