EXTRACT EXTMOL02
SETENV (NLS_LANG="ENGLISH_UNITED KINGDOM.WE8ISO8859P1")
SETENV (ORACLE_SID=molintpc1)
USERID ggate, PASSWORD ggate123
CACHEMGR CACHESIZE 8G
TRANLOGOPTIONS DBLOGREADER
TRANLOGOPTIONS BUFSIZE 4096000
TRANLOGOPTIONS DBLOGREADERBUFSIZE 4096000
TRANLOGOPTIONS EXCLUDEUSER GGATE
-- DISCARDFILE ./dirrpt/discmol.txt, APPEND, MEGABYTES 100
-- DISCARDROLLOVER ON MONDAY
EXTTRAIL ./dirdat/lm, format release 11.2
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.IMAGES, GETBEFORECOLS (ON UPDATE ALLEXCLUDING (IMAGE_TAGS));
TABLE MAILONLINE.QRTZ_TRIGGERS, GETBEFORECOLS (ON UPDATE ALLEXCLUDING (JOB_DATA));
TABLE MAILONLINE.MODULES_IMAGES, GETBEFORECOLS (ON UPDATE ALL);
TABLE MAILONLINE.LINK_LIST_GROUP, GETBEFORECOLS (ON UPDATE KEYINCLUDING (MODIFIED_DATE));
TABLE MAILONLINE.LINK_LIST_ITEMS, GETBEFORECOLS (ON UPDATE ALL);
TABLE MAILONLINE.CMS_SCRATCHPAD, GETBEFORECOLS (ON UPDATE ALL, ON DELETE ALL);
TABLE MAILONLINE.VM_VIDEO, GETBEFORECOLS (ON UPDATE KEYINCLUDING (MODIFIED_DATE));
TABLE MAILONLINE.RELATED_ARTICLES, GETBEFORECOLS (ON UPDATE ALL);
TABLE MAILONLINE.QRTZ_TRIGGER_LISTENERS, GETBEFORECOLS (ON DELETE KEY);
TABLE MAILONLINE.QRTZ_FIRED_TRIGGERS GETBEFORECOLS (ON DELETE KEY);
TABLE MAILONLINE.ASSET_PUBLISHER_LAST_RUN, GETBEFORECOLS (ON UPDATE ALL), KEYCOLS(ITEM_TYPE);
TABLE MAILONLINE.ARTICLES_VERSIONS, GETBEFORECOLS (ON UPDATE KEYINCLUDING (MODIFIED_DATE));
TABLE MAILONLINE.*;
TABLEEXCLUDE MAILONLINE.MV_LATEST_ARTICLE_AUTHOR;


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

EXTRACT EXTRDC02
SETENV (NLS_LANG="ENGLISH_UNITED KINGDOM.WE8ISO8859P1")
SETENV (ORACLE_SID=molintpc1)
USERID ggate, PASSWORD ggate123
CACHEMGR CACHESIZE 8G
TRANLOGOPTIONS DBLOGREADER
TRANLOGOPTIONS BUFSIZE 4096000
TRANLOGOPTIONS DBLOGREADERBUFSIZE 4096000
TRANLOGOPTIONS EXCLUDEUSER GGATE
-- DISCARDFILE ./dirrpt/discrdc.txt, APPEND, MEGABYTES 100
-- DISCARDROLLOVER ON MONDAY
EXTTRAIL ./dirdat/cr, format release 11.2
TABLE RDRCOMMENTS.RC_ASSET, GETBEFORECOLS (ON UPDATE KEYINCLUDING (LAST_UPDATED, COMMENT_COUNT));
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.*;


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

EXTRACT EXTREG02
SETENV (NLS_LANG="ENGLISH_UNITED KINGDOM.WE8ISO8859P1")
SETENV (ORACLE_SID=molintpc1)
USERID ggate, PASSWORD ggate123
CACHEMGR CACHESIZE 8G
TRANLOGOPTIONS DBLOGREADER
TRANLOGOPTIONS BUFSIZE 4096000
TRANLOGOPTIONS DBLOGREADERBUFSIZE 4096000
TRANLOGOPTIONS EXCLUDEUSER GGATE
EXTTRAIL ./dirdat/gr, format release 11.2
TABLE REGISTRATION.REGISTERED_USER, GETBEFORECOLS (ON UPDATE KEYINCLUDING (UPDATED_DATE), ON DELETE KEY);
TABLE REGISTRATION.*;


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

EXTRACT EXTOTH02
SETENV (NLS_LANG="ENGLISH_UNITED KINGDOM.WE8ISO8859P1")
SETENV (ORACLE_SID=molintpc1)
USERID ggate, PASSWORD ggate123
CACHEMGR CACHESIZE 4G
TRANLOGOPTIONS DBLOGREADER
TRANLOGOPTIONS BUFSIZE 4096000
TRANLOGOPTIONS DBLOGREADERBUFSIZE 4096000
TRANLOGOPTIONS EXCLUDEUSER GGATE
-- DISCARDFILE ./dirrpt/discoth.txt, APPEND, MEGABYTES 100
-- DISCARDROLLOVER ON MONDAY
EXTTRAIL ./dirdat/to, format release 11.2
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.*;