Get Data Moving 1
Results 1 to 3 of 3

Thread: Manual setting of Oracle supplemental logging

  1. #1
    JeffInFlorida's Avatar
    JeffInFlorida is offline US Technical Team
    Join Date
    Oct 2006
    Posts
    95
    Rep Power
    13

    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
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  2. #2
    Arbind Karna is offline Junior Member
    Join Date
    Apr 2013
    Posts
    2
    Rep Power
    0
    Thank you for sharing these steps !

    After enabling the supplimental logging in source database, why every day a soft directory is created in Oracle database pointing to the archive log location? In 30 days, i can see 125 directories created in Oracle in ownership of SYS schema and i am not sure if we can drop those directories or not and what is using it?

    Please suggest.

    Thank You !

  3. #3
    Gadi.Farhat is offline Development Manager
    Join Date
    Mar 2009
    Posts
    255
    Rep Power
    11
    I suggest you check the logs.

    Do the user connecting to Oracle has drop directory privileges?

    Regards,

    Gadi
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

Tags for this Thread

Posting Permissions

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