Re: Using Dataguard for a cut down reporting database

You might want to look into Oracle streams - a new 9i feature ... If I remember correctly it's like Quest's shareplex in that it uses the online and offline redofiles to replicate data to another instance. The Oracle streams implementation uses the logminer API.

It looks pretty cool and I'm going to test it out on a couple test environments for reporting purposes.

"Paul" <thompsonp_at_logica.com> wrote in message news:aaebc71a.0303190607.643e62ee_at_posting.google.com...
> I have been reading about DataGuard and its use for creating one or
> more standby databases.
>
> Is it possible to use the same features to create a reporting
> database, but limit the tables (or data within a table) that is
> maintained in the standby.
>
> For example if the primary database has a particularly large table
> with lots of activity (inserts, updates), but the reporting database
> doesn't need to see all this data, can it be configured to ignore or
> skip the elements of the shipped log files that relate to this table?
>
> Being able to do so would save time in applying the logs, but more
> importantly allow for a much smaller reporting database.
>
> Thanks
> Paul
Received on Wed Mar 19 2003 - 09:19:47 CST