IGNOREDELETES, IGNOREUPDATES, ignoredeletes

Source: Internet
Author: User

IGNOREDELETES, IGNOREUPDATES, ignoredeletes

Sometimes, when we do not want to update or delete the data of the target ogg application, we can use the IGNOREDELETES and IGNOREUPDATES parameters.

GETDELETES | IGNOREDELETES
Valid for Extract and Replicat
Use the GETDELETES and IGNOREDELETES parameters to control whether or not Oracle
GoldenGate processes delete operations. These parameters are table-specific. One
Parameter remains in effect for all subsequent TABLE or MAP statements, until the other
Parameter is encountered.
Default GETDELETES
Syntax GETDELETES | IGNOREDELETES

 

GETUPDATES | IGNOREUPDATES
Valid for Extract and Replicat
Use the GETUPDATES and IGNOREUPDATES parameters to control whether or not Oracle
GoldenGate processes update operations. The parameters are table-specific. One
Parameter remains in effect for all subsequent TABLE or MAP statements, until the other
Parameter is encountered.
Default GETUPDATES
Syntax GETUPDATES | IGNOREUPDATES

 

For example:

 

REPLICAT zbdba
ASSUMETARGETDEFS
USERID ogg_zbdba, PASSWORD ogg_oracle
IGNOREDELETES
IGNOREUPDATES
MAP zbdba. test, TARGET zbdba. test;



    What is the difference between ignore and neglect?

    Ignore deliberately ignores and ignores

    He completely ignored all these facts as though they never existed.
    He ignores all of this, as if they do not exist at all.
    She saw him coming but she ignored him.
    She saw him come, but she didn't see him.

    Negelect is omitted and neglected.

    Fall into neglect is gradually ignored [ignore]
    In a state of neglect in unattended state
    Treat sb. with neglect someone
    Reference: baidu

    What is the difference between omit and ignore in English?

    Ignore has a strong ignoring subjective ignoring.
    Omit negligence and omission mostly the omission of objectivity.
    Reference: zhidao.baidu.com/question/48900872.html

    Related Article

    Contact Us

    The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

    If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

    A Free Trial That Lets You Build Big!

    Start building with 50+ products and up to 12 months usage for Elastic Compute Service

    • Sales Support

      1 on 1 presale consultation

    • After-Sales Support

      24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.