RE: replication

One of the ways to archive/purge data based on time interval: 1. Tables should be partitioned by date-type column; 2. When it comes time to purge data, exchange data in partition to be purged with the table in "transportable" tablespace, then drop this partition.
3. Move transportable tablespace to "archive" system, attach. 4. Exchange data in the table in transportable tablespace with the partitioned table, which stores archived data.

So, you should start reading about Partitioning and Transportable tablespaces.

Igor

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Veres Lajos Sent: Tuesday, December 13, 2005 5:09 PM To: oracle-l_at_freelists.org
Subject: replication

Hello,

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.

Thanks.
--

Veres Lajos
vlajos_at_ludens.elte.hu
+36 20 438 5909
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Dec 14 2005 - 07:54:28 CST