Data Replication 2
Results 1 to 2 of 2

Thread: Manual Setting Of Oracle Supplemental Logging

  1. #1
    fineleric9x is offline Junior Member
    Join Date
    Apr 2018
    Posts
    1
    Rep Power
    0

    Manual Setting Of Oracle Supplemental Logging

    If you do not want to let Replicate automaticly set supplemental logging then here are your options:

    One option is to run the following on the database level:

    ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY, UNIQUE) COLUMNS;

    And the following for every table that has manipulation, filter on columns that are not part of the PK, or tables that do not have a primary key.

    ALTER TABLE XXX ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;

    The other option is to run the following on the database level:

    ALTER DATABASE ADD SUPPLEMENTAL LOG DATA

    And then for every table:


    • If the table has a primary key:



    ALTER TABLE xxx ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS



    • If the table doesn’t have a primary key and have a unique index:



    ALTER TABLE xxx ADD SUPPLEMENTAL LOG GROUP (first unique index columns) ALWAYS



    • If the table doesn’t have a primary key or a unique index or if it has a manipulation or a filter defined on columns that are not part of the PK:



    ALTER TABLE xxx ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS

  2. #2
    ena-william is offline Junior Member
    Join Date
    Jun 2018
    Posts
    1
    Rep Power
    0
    Hello
    I am new for this forum



    __________________
    bali tour packages for couple

Posting Permissions

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