DB Wiki

EXTRACT EXTMOL01
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/discEXTMOL.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/ml

NODYNAMICRESOLUTION

TABLE MAILONLINE.PARSED_ARTICLES,
      GETBEFORECOLS (ON UPDATE ALLEXCLUDING (ARTICLE_TEXT));

TABLE MAILONLINE.ARTICLES,
      GETBEFORECOLS (ON UPDATE ALLEXCLUDING (ARTICLE_TEXT));

TABLE MAILONLINE.MODULES,
      GETBEFORECOLS (ON UPDATE ALLEXCLUDING (TEXT));

TABLE MAILONLINE.LINK_LIST_GROUP,
      GETBEFORECOLS (ON UPDATE ALL);

TABLE MAILONLINE.CMS_SCRATCHPAD,
      GETBEFORECOLS (ON UPDATE ALL, ON DELETE ALL);

TABLE MAILONLINE.VM_VIDEO,
      GETBEFORECOLS (ON UPDATE ALL);

TABLE MAILONLINE.ASSET_PUBLISHER_LAST_RUN, KEYCOLS(ITEM_TYPE),
      GETBEFORECOLS (ON UPDATE ALL);

TABLE MAILONLINE.QRTZ_TRIGGER_LISTENERS, GETBEFORECOLS (ON DELETE KEY);

TABLE MAILONLINE.QRTZ_FIRED_TRIGGERS, GETBEFORECOLS (ON DELETE KEY);

TABLE MAILONLINE.QRTZ_SCHEDULER_STATE, GETBEFORECOLS (ON UPDATE ALL, ON DELETE ALL);

TABLE MAILONLINE.ARTICLES_VERSIONS,
      GETBEFORECOLS (ON UPDATE ALLEXCLUDING (ARTICLE_TEXT, ARTICLE_PARSED_TEXT));

TABLE MAILONLINE.USER_TRANSFER_ITEM, GETBEFORECOLS (ON DELETE KEY);

TABLE MAILONLINE.RELATED_ARTICLES,
      GETBEFORECOLS (ON UPDATE ALL);

DYNAMICRESOLUTION
IGNOREUPDATEBEFORES

DDL INCLUDE ALL, EXCLUDE OBJTYPE 'USER'
DDLOPTIONS REPORT, IGNOREREPLICATES, GETAPPLOPS

TABLEEXCLUDE MAILONLINE.MV_LATEST_ARTICLE_AUTHOR;
TABLE MAILONLINE.*;

EXTRACT EXTRDC01
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/discEXTRDC.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/rc

NODYNAMICRESOLUTION
TABLE RDRCOMMENTS.RC_COMMENT GETBEFORECOLS (ON UPDATE ALL, ON DELETE KEY);
TABLE RDRCOMMENTS.RC_USER    GETBEFORECOLS (ON UPDATE ALL);
TABLE RDRCOMMENTS.RC_ASSET   GETBEFORECOLS (ON UPDATE ALL);

DYNAMICRESOLUTION

TABLE 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.*;