DB Wiki

REPLICAT REPMOL01
SETENV (NLS_LANG="ENGLISH_UNITED KINGDOM.WE8ISO8859P1")
USERID ggate@molbb, PASSWORD password
ASSUMETARGETDEFS
DBOPTIONS SUPPRESSTRIGGERS
DISCARDFILE ./dirrpt/discREPMOL.dsc, APPEND, MEGABYTES 100
DISCARDROLLOVER ON MONDAY
DDL INCLUDE ALL
DDLOPTIONS REPORT
DDLERROR 955 DISCARD
DDLERROR 1031 DISCARD
DDLERROR 24344 DISCARD
REPORTCOUNT EVERY 10 MINUTES, RATE
REPORTROLLOVER AT 00:00 ON MONDAY
INCLUDE ./dirprm/macros/exceptions.inc

-- Exceptions logging removed from USER_TRANSFER_ITEMS
-- This is due to a Cascade Delete foreign key which was filling 
-- EXCEPTIONS table up with "ORA-01403: no data found" messages
MAP MAILONLINE.USER_TRANSFER_ITEM, TARGET MAILONLINE.USER_TRANSFER_ITEM,
      COMPARECOLS (ON DELETE KEY),
   RESOLVECONFLICT (DELETEROWEXISTS, (DEFAULT, DISCARD)),
   RESOLVECONFLICT (DELETEROWMISSING, (DEFAULT, DISCARD));

MAP MAILONLINE.ARTICLES, TARGET MAILONLINE.ARTICLES,
       COMPARECOLS (ON UPDATE ALLEXCLUDING (ARTICLE_TEXT)),
    RESOLVECONFLICT (UPDATEROWEXISTS, (DEFAULT, USEMAX (MODIFIED_DATE))),
    RESOLVECONFLICT (UPDATEROWMISSING, (DEFAULT, OVERWRITE));
MAP MAILONLINE.ARTICLES, TARGET GGATE.EXCEPTIONS,
    EXCEPTIONSONLY, INSERTALLRECORDS, COLMAP (#exceptioncols());

MAP MAILONLINE.PARSED_ARTICLES, TARGET MAILONLINE.PARSED_ARTICLES,
      COMPARECOLS (ON UPDATE ALLEXCLUDING (ARTICLE_TEXT)),
   RESOLVECONFLICT (UPDATEROWEXISTS, (DEFAULT, USEMAX (MODIFIED_DATE))),
   RESOLVECONFLICT (UPDATEROWMISSING, (DEFAULT, OVERWRITE));
MAP MAILONLINE.PARSED_ARTICLES, TARGET GGATE.EXCEPTIONS,
   EXCEPTIONSONLY, INSERTALLRECORDS, COLMAP (#exceptioncols());

MAP MAILONLINE.CMS_SCRATCHPAD, TARGET MAILONLINE.CMS_SCRATCHPAD,
       COMPARECOLS (ON DELETE ALL),
    RESOLVECONFLICT (DELETEROWEXISTS, (DEFAULT, DISCARD)),
    RESOLVECONFLICT (DELETEROWMISSING, (DEFAULT, DISCARD));
MAP MAILONLINE.CMS_SCRATCHPAD, TARGET GGATE.EXCEPTIONS,
    EXCEPTIONSONLY, INSERTALLRECORDS, COLMAP (#exceptioncols());

MAP MAILONLINE.MODULES, TARGET MAILONLINE.MODULES,
       COMPARECOLS (ON UPDATE KEYINCLUDING (MODIFIED_DATE)),
    RESOLVECONFLICT (UPDATEROWEXISTS, (DEFAULT, USEMAX (MODIFIED_DATE))),
    RESOLVECONFLICT (UPDATEROWMISSING, (DEFAULT, OVERWRITE));
MAP MAILONLINE.MODULES, TARGET GGATE.EXCEPTIONS,
    EXCEPTIONSONLY, INSERTALLRECORDS, COLMAP (#exceptioncols());

MAP MAILONLINE.VM_VIDEO, TARGET MAILONLINE.VM_VIDEO,
    COMPARECOLS (ON UPDATE KEYINCLUDING (MODIFIED_DATE)),
    RESOLVECONFLICT (UPDATEROWEXISTS, (DEFAULT, USEMAX (MODIFIED_DATE))),
    RESOLVECONFLICT (UPDATEROWMISSING, (DEFAULT, OVERWRITE));
MAP MAILONLINE.VM_VIDEO, TARGET GGATE.EXCEPTIONS,
    EXCEPTIONSONLY, INSERTALLRECORDS, COLMAP (#exceptioncols());

MAP MAILONLINE.QRTZ_SCHEDULER_STATE, TARGET MAILONLINE.QRTZ_SCHEDULER_STATE,
      COMPARECOLS (ON UPDATE ALL, ON DELETE ALL),
    RESOLVECONFLICT (UPDATEROWEXISTS, (DEFAULT, OVERWRITE)),
    RESOLVECONFLICT (UPDATEROWMISSING, (DEFAULT, OVERWRITE)),
    RESOLVECONFLICT (DELETEROWEXISTS, (DEFAULT, DISCARD)),
    RESOLVECONFLICT (DELETEROWMISSING, (DEFAULT, DISCARD)),
    REPERROR (1, IGNORE);
MAP MAILONLINE.QRTZ_SCHEDULER_STATE, TARGET GGATE.EXCEPTIONS,
    EXCEPTIONSONLY, INSERTALLRECORDS, COLMAP (#exceptioncols());

MAP MAILONLINE.ASSET_PUBLISHER_LAST_RUN, TARGET MAILONLINE.ASSET_PUBLISHER_LAST_RUN,
       KEYCOLS(ITEM_TYPE),
    RESOLVECONFLICT (UPDATEROWEXISTS, (DEFAULT, USEMAX (LAST_RUN_DATE)));
MAP MAILONLINE.ASSET_PUBLISHER_LAST_RUN, TARGET GGATE.EXCEPTIONS,
    EXCEPTIONSONLY, INSERTALLRECORDS, COLMAP (#exceptioncols());

MAP MAILONLINE.QRTZ_TRIGGER_LISTENERS, TARGET MAILONLINE.QRTZ_TRIGGER_LISTENERS,
       COMPARECOLS (ON DELETE KEY),
    RESOLVECONFLICT (DELETEROWEXISTS, (DEFAULT, DISCARD)),
    RESOLVECONFLICT (DELETEROWMISSING, (DEFAULT, DISCARD));
MAP MAILONLINE.QRTZ_TRIGGER_LISTENERS, TARGET GGATE.EXCEPTIONS,
    EXCEPTIONSONLY, INSERTALLRECORDS, COLMAP (#exceptioncols());

MAP MAILONLINE.QRTZ_FIRED_TRIGGERS, TARGET MAILONLINE.QRTZ_FIRED_TRIGGERS,
       COMPARECOLS (ON DELETE KEY),
    RESOLVECONFLICT (DELETEROWEXISTS, (DEFAULT, DISCARD)),
    RESOLVECONFLICT (DELETEROWMISSING, (DEFAULT, DISCARD));
MAP MAILONLINE.QRTZ_FIRED_TRIGGERS, TARGET GGATE.EXCEPTIONS,
    EXCEPTIONSONLY, INSERTALLRECORDS, COLMAP (#exceptioncols());

MAP MAILONLINE.ARTICLES_VERSIONS, TARGET MAILONLINE.ARTICLES_VERSIONS,
       COMPARECOLS (ON UPDATE ALLEXCLUDING (ARTICLE_TEXT, ARTICLE_PARSED_TEXT)),
    RESOLVECONFLICT (UPDATEROWEXISTS, (DEFAULT, USEMAX (MODIFIED_DATE))),
    RESOLVECONFLICT (UPDATEROWMISSING, (DEFAULT, OVERWRITE));
MAP MAILONLINE.ARTICLES_VERSIONS, TARGET GGATE.EXCEPTIONS,
    EXCEPTIONSONLY, INSERTALLRECORDS, COLMAP (#exceptioncols());

MAPEXCLUDE MAILONLINE.MV_LATEST_ARTICLE_AUTHOR;
MAPEXCLUDE MAILONLINE.SYS_IMPORT_FULL_*;

MAP MAILONLINE.*, TARGET MAILONLINE.*;

REPLICAT REPRDC01
SETENV (NLS_LANG="ENGLISH_UNITED KINGDOM.WE8ISO8859P1")
USERID ggate@molbb, PASSWORD password
DBOPTIONS SUPPRESSTRIGGERS
ASSUMETARGETDEFS
DISCARDFILE ./dirrpt/discREPRDC.dsc, APPEND, MEGABYTES 100
DISCARDROLLOVER ON MONDAY
REPORTCOUNT EVERY 10 MINUTES, RATE
REPORTROLLOVER AT 00:00 ON MONDAY
INCLUDE ./dirprm/macros/exceptions.inc

MAP RDRCOMMENTS.RC_COMMENT, TARGET RDRCOMMENTS.RC_COMMENT,
    COMPARECOLS (ON UPDATE KEYINCLUDING (LAST_UPDATED, VOTE_COUNT, VOTE_RATING), ON DELETE KEY),
    RESOLVECONFLICT (UPDATEROWEXISTS, (delta_res_method, USEDELTA, COLS (VOTE_COUNT, VOTE_RATING)), (DEFAULT, USEMAX (LAST_UPDATED))),
    RESOLVECONFLICT (UPDATEROWMISSING, (DEFAULT, OVERWRITE)),
    RESOLVECONFLICT (DELETEROWEXISTS, (DEFAULT, DISCARD)),
    RESOLVECONFLICT (DELETEROWMISSING, (DEFAULT, IGNORE));
MAP RDRCOMMENTS.RC_COMMENT, TARGET GGATE.EXCEPTIONS,
    EXCEPTIONSONLY, INSERTALLRECORDS, COLMAP (#exceptioncols());

MAP RDRCOMMENTS.RC_USER, TARGET RDRCOMMENTS.RC_USER,
    COMPARECOLS (ON UPDATE KEYINCLUDING (LAST_UPDATED, VOTE_COUNT, VOTE_RATING)),
    RESOLVECONFLICT (UPDATEROWEXISTS, (delta_res_method, USEDELTA, COLS (VOTE_COUNT, VOTE_RATING)), (DEFAULT, USEMAX (LAST_UPDATED))),
    RESOLVECONFLICT (UPDATEROWMISSING, (DEFAULT, OVERWRITE));
MAP RDRCOMMENTS.RC_USER, TARGET GGATE.EXCEPTIONS,
    EXCEPTIONSONLY, INSERTALLRECORDS, COLMAP (#exceptioncols());

MAP RDRCOMMENTS.RC_ASSET, TARGET RDRCOMMENTS.RC_ASSET,
    COMPARECOLS (ON UPDATE KEYINCLUDING (LAST_UPDATED, COMMENT_COUNT)),
    RESOLVECONFLICT (UPDATEROWEXISTS, (DEFAULT, USEMAX (LAST_UPDATED))),
    RESOLVECONFLICT (UPDATEROWMISSING, (DEFAULT, OVERWRITE));
MAP RDRCOMMENTS.RC_ASSET, TARGET GGATE.EXCEPTIONS,
    EXCEPTIONSONLY, INSERTALLRECORDS, COLMAP (#exceptioncols());

MAP RDRCOMMENTS.*, TARGET RDRCOMMENTS.*;

EXTRACT EXTREG01
SETENV (NLS_LANG="ENGLISH_UNITED KINGDOM.WE8ISO8859P1")
USERID ggate@andracaa, PASSWORD password
TRANLOGOPTIONS DBLOGREADER
TRANLOGOPTIONS BUFSIZE 4096000
TRANLOGOPTIONS DBLOGREADERBUFSIZE 4096000
TRANLOGOPTIONS EXCLUDEUSER GGATE
DISCARDFILE ./dirrpt/discEXTREG.txt, APPEND, MEGABYTES 100
DISCARDROLLOVER ON MONDAY
WARNLONGTRANS 30m, CHECKINTERVAL 5m
REPORTCOUNT EVERY 10 MINUTES, RATE
REPORTROLLOVER AT 00:00 ON MONDAY
EXTTRAIL ./dirdat/source/rg

NODYNAMICRESOLUTION

TABLE REGISTRATION.REGISTERED_USER GETBEFORECOLS (ON UPDATE ALL, ON DELETE KEY);

DYNAMICRESOLUTION
TABLE REGISTRATION.*;

Check the list of schemas below to ensure that there have been no new schemas created recently.

EXTRACT EXTOTH01
SETENV (NLS_LANG="ENGLISH_UNITED KINGDOM.WE8ISO8859P1")
USERID ggate@andracaa, PASSWORD password
TRANLOGOPTIONS DBLOGREADER
TRANLOGOPTIONS BUFSIZE 4096000
TRANLOGOPTIONS DBLOGREADERBUFSIZE 4096000
TRANLOGOPTIONS EXCLUDEUSER GGATE
WARNLONGTRANS 30m, CHECKINTERVAL 5m
REPORTCOUNT EVERY 10 MINUTES, RATE
REPORTROLLOVER AT 00:00 ON MONDAY
DISCARDFILE ./dirrpt/discEXTOTH.txt, APPEND, MEGABYTES 100
DISCARDROLLOVER ON MONDAY
EXTTRAIL ./dirdat/source/ot

NODYNAMICRESOLUTION
TABLE FBIAGENT.ARTICLE, GETBEFORECOLS (ON UPDATE ALL);

DYNAMICRESOLUTION
TABLE ANALYTICS.*;
TABLE ANDCOMMUNITIES.*;
TABLE APTECO.*;
TABLE BOARDSMIG.*;
TABLE CLEARSPACE.*;
TABLE CSMIG.*;
TABLE EAGLEEYE.*;
TABLE FBIAGENT.*;
TABLE GATEKEEPER.*;
TABLE GATEKEEPERADMIN.*;
TABLE GKREAD.*;
TABLE JIVETILREAD.*;
TABLE JOBMANAGER.*;
TABLE LEGAL.*;
TABLE MAILREAD.*;
TABLE MOFEEDS.*;
TABLE MOLAPP.*;
TABLE MOLEM.*;
TABLE MOLSUPP.*;
TABLE MOUSER.*;
TABLE RCREAD.*;
TABLE RCUSER.*;
TABLE REGREAD.*;
TABLE SCHOOL.*;
TABLE TILDUMMY.*;
TABLE TIMBOARDS.*;
TABLE TIMDEBATE.*;
TABLE TRAVELMAIL.*;