This discussion is archived
3 Replies Latest reply: Jul 30, 2012 4:56 AM by 878904 RSS

Extract params -  wildcard resolution

878904 Newbie
Currently Being Moderated
Hello

Below is an excerpt from an extract param file

....
-- get deletes for these tables
GETDELETES
TABLE scott.gg_test;

IGNOREDELETES
--- exclude tables for which we get deletes
TABLEEXCLUDE scott.gg_test

--- push rest with no deletes
TABLE scott.*;
....

I want to capture deletes for all tables but scott.gg_test. However, this does not happen. All DML for the table gg_test is ignored ! Pushing the first 2 lines to be after the 'TABLE scott.*' causes duplicates on inserts.
Any ideas on how I can use the wildcard with a TABLEEXCLUDE and and then include the excluded table with diff DML capture options ?

Varad




Varad
  • 1. Re: Extract params -  wildcard resolution
    J_K Newbie
    Currently Being Moderated
    As per document ,

    TABLEEXCLUDE must precede all TABLE and SEQUENCE statements that contain the objects that you want to exclude.

    TABLEEXCLUDE scott.gg_test
    TABLE scott.*;

    Try .

    IGNOREDELTE
    tableexclude scott.gg_test;

    GETDELETE
    TABLE SCOTT.*;

    these can be also helpful.

    REPLICAT repcust
    USERID ogg, PASSWORD AACAAAAAAAAAAAJAUEUGODSCVGJEEIUGKJDJTFNDKEJFFFTC &
    AES128, ENCRYPTKEY securekey1
    SOURCEDEFS /ggs/dirdef/source.def
    ALLOWDUPTARGETMAP
    GETINSERTS
    GETUPDATES
    IGNOREDELETES
    MAP ggs.tcustmer, TARGET ggs.tcustmer, COLMAP (USEDEFAULTS, deleted_row
    = "N");
    IGNOREINSERTS
    IGNOREUPDATES
    GETDELETES
    UPDATEDELETES
    MAP ggs.tcustmer, TARGET ggs.tcustmer, COLMAP (USEDEFAULTS,
    deleted_row = "Y");
  • 2. Re: Extract params -  wildcard resolution
    878904 Newbie
    Currently Being Moderated
    Ooops !

    I meant to write 'I want to IGNORE deletes for all tables but scott.gg_test'

    I will try your suggestion for the Replicat.Not sure if I need full supplemental logging to convert deletes to updates...

    Varad
  • 3. Re: Extract params -  wildcard resolution
    878904 Newbie
    Currently Being Moderated
    This works for me in the Extract Param file


    ..
    --- push all with no deletes
    IGNOREDELETES
    TABLE scott.*;


    -- get deletes for these tables
    GETDELETES
    IGNOREINSERTS
    IGNOREUPDATES
    TABLE scott.gg_test;

    ...

    Thanks for the tip j/k


    Varad

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points