"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.
Received on Wed Jul 02 2003 - 12:06:32 CDT
