Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2006
    Posts
    11

    Question Unanswered: Question about Supplemental Logging

    I enabled the Supplemental Logging for capture the columns when an Update operation issues.
    I enabled it at database level by :
    > alter database add supplemental log data (primary key, unique index) columns;

    But things didn't work as I images. The primary key is always logged in the redo log, but the columns which is "NOT NULL" didn't contain in the redo log.
    I thought the "unique index" indicate that the "NOT NULL" column which isn't primary key will log into redo log.

    All I could image is that the "unique index" is an conditional log while the "primary key" is an unconditional log.

    So should I enable unconditional log of specific columns at table level instead of "unique index" at database level?



    Black Thought

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Code:
    SQL> alter database add supplemental log data (primary key, unique index) columns;
    
    Database altered.
    
    SQL> select SUPPLEMENTAL_LOG_DATA_PK, SUPPLEMENTAL_LOG_DATA_UI from v$database;
    
    SUP SUP
    --- ---
    YES YES
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Sep 2006
    Posts
    11
    Yes, it has been successfully set, but have you verified this?
    I didn't see any "Unique Index" column be logged in the redo log.

Posting Permissions

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