EXTRACT EXTMOL01
SETENV (NLS_LANG="ENGLISH_UNITED KINGDOM.WE8ISO8859P1")
SETENV (ORACLE_SID=molint1)
USERID ggate, PASSWORD ggate123
TRANLOGOPTIONS DBLOGREADER
TRANLOGOPTIONS BUFSIZE 4096000
TRANLOGOPTIONS DBLOGREADERBUFSIZE 4096000
TRANLOGOPTIONS EXCLUDEUSER GGATE
DISCARDFILE ./dirrpt/discmol.txt, APPEND, MEGABYTES 100
DISCARDROLLOVER ON MONDAY
EXTTRAIL ./dirdat/ml

NODYNAMICRESOLUTION

TABLE MAILONLINE.PARSED_ARTICLES,
      GETBEFORECOLS
        (ON UPDATE KEYINCLUDING (CHANNEL_ID,STATUS_ID,HEADLINE,MODIFIED_BY,MODIFIED_DATE,READER_COMMENTS,ARTICLE_STYLE_ID));

TABLE MAILONLINE.ARTICLES,
      GETBEFORECOLS
        (ON UPDATE KEYINCLUDING (CHANNEL_ID,STATUS_ID,HEADLINE,MODIFIED_BY,MODIFIED_DATE,READER_COMMENTS,ARTICLE_STYLE_ID));

TABLE MAILONLINE.MODULES, GETBEFORECOLS (ON UPDATE KEYINCLUDING (MODIFIED_DATE));

TABLE MAILONLINE.LINK_LIST_GROUP, GETBEFORECOLS (ON UPDATE KEYINCLUDING (MODIFIED_DATE));

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

TABLE MAILONLINE.VM_VIDEO, GETBEFORECOLS (ON UPDATE KEYINCLUDING (MODIFIED_DATE));

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

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

TABLE MAILONLINE.QRTZ_FIRED_TRIGGERS GETBEFORECOLS (ON DELETE KEY);

TABLE MAILONLINE.ARTICLES_VERSIONS, GETBEFORECOLS (ON UPDATE KEYINCLUDING (MODIFIED_DATE));

DYNAMICRESOLUTION
DDL INCLUDE MAPPED
TABLE MAILONLINE.*;

TABLEEXCLUDE MAILONLINE.MV_LATEST_ARTICLE_AUTHOR;

-- Special table which monitors lag
TABLE GGS_MON.GGS_HEARTBEAT ,
   TOKENS ( host = @GETENV ("GGENVIRONMENT" , "HOSTNAME") );
   
-----------------------------------------------------------------------------------------------------------------------------------

EXTRACT EXTRDC01
SETENV (NLS_LANG="ENGLISH_UNITED KINGDOM.WE8ISO8859P1")
SETENV (ORACLE_SID=molint1)
USERID ggate, PASSWORD ggate123
TRANLOGOPTIONS DBLOGREADER
TRANLOGOPTIONS BUFSIZE 4096000
TRANLOGOPTIONS DBLOGREADERBUFSIZE 4096000
TRANLOGOPTIONS EXCLUDEUSER GGATE
DISCARDFILE ./dirrpt/discrdc.txt, APPEND, MEGABYTES 100
DISCARDROLLOVER ON MONDAY
EXTTRAIL ./dirdat/rc
NODYNAMICRESOLUTION
TABLE RDRCOMMENTS.RC_COMMENT,
    GETBEFORECOLS (ON UPDATE KEYINCLUDING (LAST_UPDATED, VOTE_COUNT, VOTE_RATING), ON DELETE KEY);
TABLE RDRCOMMENTS.RC_USER,
    GETBEFORECOLS (ON UPDATE KEYINCLUDING (LAST_UPDATED, VOTE_COUNT, VOTE_RATING));
TABLE RDRCOMMENTS.RC_ASSET,
    GETBEFORECOLS (ON UPDATE KEYINCLUDING (LAST_UPDATED, COMMENT_COUNT));
DYNAMICRESOLUTION
DDL INCLUDE MAPPED
TABLE RDRCOMMENTS.*;

------------------------------------------------------------------------------------------------------------------------------------

EXTRACT EXTREG01
SETENV (NLS_LANG="ENGLISH_UNITED KINGDOM.WE8ISO8859P1")
SETENV (ORACLE_SID=molint1)
USERID ggate, PASSWORD ggate123
TRANLOGOPTIONS DBLOGREADER
TRANLOGOPTIONS BUFSIZE 4096000
TRANLOGOPTIONS DBLOGREADERBUFSIZE 4096000
TRANLOGOPTIONS EXCLUDEUSER GGATE
DISCARDFILE ./dirrpt/discreg.txt, APPEND, MEGABYTES 100
DISCARDROLLOVER ON MONDAY
EXTTRAIL ./dirdat/rg
NODYNAMICRESOLUTION
TABLE REGISTRATION.REGISTERED_USER, GETBEFORECOLS (ON UPDATE KEYINCLUDING (UPDATED_DATE), ON DELETE KEY);
DYNAMICRESOLUTION
DDL INCLUDE MAPPED
TABLE REGISTRATION.*;

--------------------------------------------------------------------------------------------------------------------------------------

EXTRACT EXTOTH01
SETENV (NLS_LANG="ENGLISH_UNITED KINGDOM.WE8ISO8859P1")
SETENV (ORACLE_SID=molint1)
USERID ggate, PASSWORD ggate123
TRANLOGOPTIONS DBLOGREADER
TRANLOGOPTIONS BUFSIZE 4096000
TRANLOGOPTIONS DBLOGREADERBUFSIZE 4096000
TRANLOGOPTIONS EXCLUDEUSER GGATE
DDL INCLUDE MAPPED
DISCARDFILE ./dirrpt/discoth.txt, APPEND, MEGABYTES 100
DISCARDROLLOVER ON MONDAY
EXTTRAIL ./dirdat/ot
TABLE ANALYTICS.*;
TABLE ANDCOMMUNITIES.*;
TABLE APTECO.*;
TABLE BOARDSMIG.*;
TABLE CLEARSPACE.*;
TABLE CSMIG.*;
TABLE EAGLEEYE.*;
TABLE GATEKEEPER.*;
TABLE GATEKEEPERADMIN.*;
TABLE GKREAD.*;
TABLE JIVETILREAD.*;
TABLE JOBMANAGER.*;
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.*;