Oracle Replication - Stopping Deletes ? [message #75494] |
Tue, 13 April 2004 08:01 |
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 |
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
|
|
|