Re: Almost Duplicate Database

rthomas_at_blarg.net (Bob) 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

A few clarifications....
1)Do you have a couple of tables( table) that are(is) the focus of updates?
2)How often would you like your reporting system to be upated (daily weekly etc.)
On the strength of what I understood I will make the following suggestions

1)Create a database link ( between the databases) insert(append) what is not found in your reporting database after comparing the tables. 2)Spool the results of a select to a flat file and use sql loader to load into the reporting database.
Both these methods could be resource intensive depending on how much data you are moving.

HTH Received on Mon Jun 30 2003 - 12:28:16 CDT