Home » Server Options » Replication » Oracle Replication - Stopping Deletes ?
Oracle Replication - Stopping Deletes ? [message #75494] Tue, 13 April 2004 08:01 Go to next message
David Parry
Messages: 1
Registered: April 2004
Junior Member
I wonder if you could assist, we are currently running Siebel under Oracle v9, we are embarking on an Archive solution, trying to replication data which is older than 12 months to a copy of the current production database or equivalent, we would like to initiate a one-way replication when data meets a specific requirement. Our main reason for this is that the production database is becoming very large and resource hungry. Can you provide any pointers on how we could implement one-way replication from our production databasse to an archive database. Once the data has been moved to archive we want to delete from production but not have the deletes move across to the archive.
Re: Oracle Replication - Stopping Deletes ? [message #75509 is a reply to message #75494] Sun, 20 June 2004 08:37 Go to previous message
Justin Cave
Messages: 8
Registered: December 2003
Junior Member
Can you identify "data older than 12 months" programmatically (i.e. is there a timestamp column)? Are you only archiving data from tables with this sort of timestamp column, or do you also want to archive reference data?

For example, if you have an item table and a sale table, it would be a lot easier to archive the sale table, but if there is an item that hasn't been sold in the last 12 months, do you want to archive that item?

Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
Previous Topic: updating primary key in replication environment
Next Topic: dbms_mview.refresh and CMP Ejb
Goto Forum:
  


Current Time: Tue Sep 30 08:08:46 CDT 2014

Total time taken to generate the page: 0.12222 seconds