Hi,
data to be archived can be moved ( I assume to another Oracle database) by:
- pl/sql procedures over database link; only relevant data is moved accross
and massaged on destination ; this is the easiest way
- advanced replication ( too much trouble)
- Oracle Streams ( I like it; have no production experience with it though);
uses archive logs
- to standby database ( data guard ); archived logs are applied at
destination database;
- triggers on source database ( which is also how adv replication works -
using internal triggers)
- even export/import ( some data massaging should happen prior to export
being done; then also on target)
Regards, Ranko
On 12/13/05, Veres Lajos <vlajos_at_ludens.elte.hu> wrote:
>
> 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 Tue Dec 13 2005 - 20:53:22 CST
