Home » Server Options » Streams & AQ » Supplemental logs (Oracle , 10.4, AIX)
Supplemental logs [message #483564] Tue, 23 November 2010 00:21 Go to next message
aankrose
Messages: 2
Registered: November 2010
Location: Chennai
Junior Member
Hi All,


I am new to Oracle Streams. Can anyone tell me when to go for unconditional supplemental log groups and when to go for conditional supplemental log groups.

Examples please .......


Thanks and Regards

Antony Ankrose J
Re: Supplemental logs [message #483571 is a reply to message #483564] Tue, 23 November 2010 02:33 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
you need to think about what supplemental logging is for: are the columns needed to identify rows to which to apply the LCRs? Are they needed by a DML handler, or for transformations? Are they necessary for all DML, or for only some operations? If the columns are always needed (for instance, as a substitute key), log them unconditionally; if some columns are needed only if other columns are changed (perhaps to insert a row in some other table), log them conditionally.
Re: Supplemental logs [message #483572 is a reply to message #483571] Tue, 23 November 2010 02:36 Go to previous message
aankrose
Messages: 2
Registered: November 2010
Location: Chennai
Junior Member
Hi John,

Thanks for your information
Previous Topic: DML / DDL Handlers
Next Topic: DML handler
Goto Forum:
  


Current Time: Thu Mar 28 11:50:27 CDT 2024