Redo Log record content. [message #346876] |
Tue, 09 September 2008 23:57 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Dipali Vithalani
Messages: 278 Registered: March 2007 Location: India
|
Senior Member |
|
|
Hi Friends,
I am studying Supplemental logging in detail. Have read lots of articles and oracle documentation about it and redo logs. But couldnot found answers of some doubts..
Please help me clear it.
Scenario: we have one table with primary key. And we execute an update query on that table which is not using the primary key column in any clause..
Question: In this case, does the redo log entry generated for the changes done by update query contain the primary columns values..?
Question:If we have any table with primary key, do we need to enable the supplemental logging on primary columns of that table? If yes, in which circumstances, do we need to enable it?
Also please suggest any good article/site which provide inside details of redo log and supplemental logging, if you know.
Regards,
Dipali..
|
|
|
|
Re: Redo Log record content. [message #346884 is a reply to message #346882] |
Wed, 10 September 2008 00:23 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Dipali Vithalani
Messages: 278 Registered: March 2007 Location: India
|
Senior Member |
|
|
I dont know the way to see/find the contect of redo log.
I want to know whether in first scenario, oracle will store primary column values or not..
If there is any way, please tell me..
Regards,
Dipali..
|
|
|
|
|
Re: Redo Log record content. [message #346899 is a reply to message #346876] |
Wed, 10 September 2008 01:05 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68680 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote: | Scenario: we have one table with primary key. And we execute an update query on that table which is not using the primary key column in any clause..
Question: In this case, does the redo log entry generated for the changes done by update query contain the primary columns values..?
|
By default, no.
If you activate supplemental logging for this, yes.
Quote: | Question:If we have any table with primary key, do we need to enable the supplemental logging on primary columns of that table? If yes, in which circumstances, do we need to enable it?
|
Do you need, generally speaking, no.
You have to for some features like Streams.
Regards
Michel
|
|
|
Re: Redo Log record content. [message #346955 is a reply to message #346899] |
Wed, 10 September 2008 03:45 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Dipali Vithalani
Messages: 278 Registered: March 2007 Location: India
|
Senior Member |
|
|
Thank you so much Michel,
I got Exactly what i was looking for.
Yes, ultimatetly, i am doing study for all this for Stream Replication..
My actual intension was to find "Do we need to enable supplemental logging on primary columns, perticularly for Stream replication" . After getting above doubts solved, i was about to ask this , if not got cleared myself.. But you are simply Superb, Dear. Before i ask, you get me.. This is where experience comes into picture. Instade of just confusing the person by asking various questions (generally not related to original quesion), got the exact point of problem and giving point to point hint.. ![Smile](images/smiley_icons/icon_smile.gif)
Thanks..
@Ana
So many things are there in this beautiful world, which all you cannot test yourself, and where you have to beleive the thing said by someone whom you trust.
In this forum, so many respected members are there, whom i can believe that, either they will put me on right path to testing (if i am going wrong), or suggst the right solution...
And, ohter things is: I never felt that i am putting my problems towards Strangers while posting my problem in our forum.
Regards,
Dipali.
|
|
|
|
|