Re: Replication Advice Needed

Sandeep,

I stand corrected. Following the link Ranko Provided I discovered step '6. Set up supplemental logging at the source database.' That triggered me to write my reply, based on my limited knowledge. Based on Data Guard experience (Logical Standby) I was only familiar with Supplemental Logging as such, which I interpreted as what appears to be known as Database Supplemental Logging.

Further reading learned there is also Table Supplemental Logging, and this is what Sanjay Mishra explains further in his article.

So, streams is an even more serious candidate to solve Charlottes replication problem.

Best regards,

Carel-Jan Engel

===
If you think education is expensive, try ignorance. (Derek Bok) ===
On Fri, 2005-09-23 at 17:11 -0400, Sandeep Dubey wrote:

> > Streams requires supplemental logging. This means that all transactions at
> > your source database will write extra logging.
>
> It does not mean you have to do supplemental logging for all
> transactions. Only updates on the tables which you want to capture
> will be supplemental logged.
>
> >Supplemental logging? Do both databases need to be on the same
> platform? This sounds almost like data guard.
>
> No. The destination database can be even non oracle.
>
> Regards
>
> Sandeep
> --
> http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l