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@xxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx > +36 20 438 5909 > -- > //www.freelists.org/webpage/oracle-l > > >