Re: Almost Duplicate Database

From: Eric Parker <eric.parker.spamless_at_virgin.net>
Date: Wed, 2 Jul 2003 10:20:11 +0100
Message-ID: <gtxMa.934$ju6.7985@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 Received on Wed Jul 02 2003 - 04:20:11 CDT