Sandeep, You might also review transportable tablespaces. I've heard many people with your situation like that for a solution. Dennis Williams On 7/13/05, Sandeep Dubey <dubey.sandeep@xxxxxxxxx> wrote: > Hi, > > I need to comeup with a replication solution. Here is the situation. > > There will be multiple master database with same database structure. > We want to replicate from these sites to a single central backupsite. > It will be many to 1 replication. Data older than 90 days will be > deleted/archived. However at the backup site we want the data to be > kept i.e we dont want to replicate this bulk delete/purge operation. > -- //www.freelists.org/webpage/oracle-l