Updating table with CLOB and impact on REDO LOG
Oracle 8i, (8,1,7 rel3) on Win2K
I have a table with 1 CLOB column (not nullable) in it, and option
ENABLE STORAGE IN ROW was used during table creation.
The usage is as follows:
Step 1. Users create record and insert into table
Step 2. Later on, other columns in the same table is updated (but not the content of the CLOB).
My question is what is the impact to REDO LOGS when this happens?
Will oracle write the content of the CLOB into the REDO LOG even
if the CLOB itself was not changed during the update?
Only the fields being updated are written in the redo log. So in your case CLOB is not written.
Click Here to Expand Forum to Full Width