Re: Almost Duplicate Database

"Ryan Gaffuri" <rgaffuri_at_cox.net> wrote in message news:1efdad5b.0307020906.47e7c211_at_posting.google.com... > "Eric Parker" <eric.parker.spamless_at_virgin.net> wrote in message news:<gtxMa.934$ju6.7985_at_newsfep4-glfd.server.ntli.net>...
> > "Bob" <rthomas_at_blarg.net> wrote in message
> > news:67f55cb1.0306300636.539018eb_at_posting.google.com...
> > > I have a production database where rows are continuously added to its
> > > tables.
> > >
> > > I need another database that is a copy of the production database for
> > > reporting purposes. In the production system, I want Rows older than
> > > 30 days to be removed. Old Rows must never be removed from the offline
> > > reporting data base. HOW DO I DO THIS?!
> > >
> > > I am not that familiar with Oracle or it's tools. DataGuard seems to
> > > make exact copies of the data, but when you delete from the production
> > > system, it deletes it from the duplicated system.
> > >
> > > Any Ideas?
> > >
> > > thanks, Bob
> >
> > Bob
> >
> > Oracle edition and version ?
> > Is your "production system" currently running without the 30 day pruning
?
> > Will your "historic" database be pruned (after 2, 7, .. years) ?
> > How soon after updates to "production" data is that data required in the
> > "historic" database ?
> > Does your "production" database have a quiet period where no changes
take
> > place ?
> >
> > I did one of these a couple of years ago with 8i where we copied
production
> > tables to
> > the historic database and did an update/insert merge every night. If I
was
> > going to do
> > this now on a 9i database I'd be looking at streams as one possible
route.
> >
> > If you need more info email me.
> >
> > HTH
> >
> > eric

>
> would any of you consider using replication for this? Im not too
> familiar with it. so just curious what you think.

Ryan

The problem with replication for this is that the deletes are replicated. As I said previously I'd look at streams to achieve this.

eric Received on Wed Jul 02 2003 - 16:21:42 CDT