We have an OLTP system.
We would like to copy some tables data into an "archive" system.

Some part of data should be the exact copy of the original, but some should be "accumulated".

In the original place there is lots of active records, but after a given period we delete some of them. (end of month)
We would like to keep deleted rows in the destination side.
(dont replicate "delete from" operations)

As I seen oracle has lots of features releated this topic, but I dont know really when I should start to read.

Could you give me some hint, keyword?

And If you have any experience with this technologies, please tell me.

Veres Lajos
+36 20 438 5909

Other related posts: