Oracle Replication / Migration Question

From: Randy <rvandehe_at_enzy.com>
Date: 23 Jan 2003 12:10:58 -0800
Message-ID: <af46bb2c.0301231210.4bbac56e@posting.google.com>

We have Oracle 8.1 on NT 4.0 with 1 instance (PROD)

We basically want to copy all the data from our prod instance to a new instance, lets call it archive (possible on another server). Then delete old records from the prod instance based on some rules. e.g. invoices older than 5 years, etc.

Basically, we want to trim the fat from our main OLTP system.

We'd like to run through this "migration" process of copying from PROD to ARCHIVE, and deleting from PROD on a regular basis, maybe as ofen as nightly, but probably weekly.

Is this something that Replication can handle? When we delete old records from PROD we don't want those "deletes" to propogate over to ARCHIVE. Or should I look at export/import scripts. I'm not too concerned about deleting the records from the PROD system, that may be as easy as building some sql/plus scripts. I'm more concerned about getting all the updates (except the deletes) to the ARCHIVE system.

-Randy Received on Thu Jan 23 2003 - 14:10:58 CST