RE: replication
- From: "Igor Neyman" <ineyman@xxxxxxxxxxxxxx>
- To: <vlajos@xxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 14 Dec 2005 08:54:17 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Veres Lajos
Sent: Tuesday, December 13, 2005 5:09 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxx
+36 20 438 5909
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
