Updating table with CLOB and impact on REDO LOG
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Updating table with CLOB and impact on REDO LOG

  1. #1
    Join Date
    Dec 2002
    Posts
    2

    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?

    Thanks.

  2. #2
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304
    Only the fields being updated are written in the redo log. So in your case CLOB is not written.
    Agasimani
    OCP(10g/9i/8i/8)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width