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
-- NOTE: Format parameter only needed for 10g to 12c replications
EXTTRAIL ./dirdat/source/ml, format release 11.2

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);

DDL INCLUDE ALL &
    EXCLUDE OBJTYPE 'USER' &
    EXCLUDE OBJNAME GGATE.*
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
-- NOTE: Format parameter only needed for 10g to 12c replications
EXTTRAIL ./dirdat/source/rc, format release 11.2

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);

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
-- NOTE: Format parameter only needed for 10g to 12c replications
EXTTRAIL ./dirdat/source/rg, format release 11.2

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

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
-- NOTE: Format parameter only needed for 10g to 12c replications
EXTTRAIL ./dirdat/source/ot, format release 11.2

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

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