| Supplemental logs [message #483564] |
Tue, 23 November 2010 00:21  |
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  |
John Watson
Messages: 8964
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
