Differences

This shows you the differences between two versions of the page.

--- replicat10g [2016/10/21 09:16] – [Registration Schema] z0hpvk
+++ replicat10g [2025/03/08 22:24] (current) – external edit 127.0.0.1
@@ Line 167: / Line 167: @@
 ==== Other Schemas ====
 Check the list of schemas below to ensure that there have been no new schemas created recently.
-<code>EXTRACT EXTOTH01
+<code>REPLICAT REPOTH01
 SETENV (NLS_LANG="ENGLISH_UNITED KINGDOM.WE8ISO8859P1")
-USERID ggate@andracaa, PASSWORD password
+USERID ggate@molbb, PASSWORD password
-TRANLOGOPTIONS DBLOGREADER
+ASSUMETARGETDEFS
-TRANLOGOPTIONS BUFSIZE 4096000
+DBOPTIONS SUPPRESSTRIGGERS
-TRANLOGOPTIONS DBLOGREADERBUFSIZE 4096000
+DISCARDFILE ./dirrpt/discREPOTH.dsc, APPEND, MEGABYTES 100
-TRANLOGOPTIONS EXCLUDEUSER GGATE
+DISCARDROLLOVER ON MONDAY
-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
+MAP FBIAGENT.ARTICLE, TARGET FBIAGENT.ARTICLE,
-TABLE FBIAGENT.ARTICLE, GETBEFORECOLS (ON UPDATE ALL);
+    COMPARECOLS (ON UPDATE ALL),
+    RESOLVECONFLICT (UPDATEROWMISSING, (DEFAULT, OVERWRITE));
-DYNAMICRESOLUTION
+MAP ANALYTICS.*, TARGET ANALYTICS.*;
-TABLE ANALYTICS.*;
+MAP ANDCOMMUNITIES.*, TARGET ANDCOMMUNITIES.*;
-TABLE ANDCOMMUNITIES.*;
+MAP APTECO.*, TARGET APTECO.*;
-TABLE APTECO.*;
+MAP BOARDSMIG.*, TARGET BOARDSMIG.*;
-TABLE BOARDSMIG.*;
+MAP CLEARSPACE.*, TARGET CLEARSPACE.*;
-TABLE CLEARSPACE.*;
+MAP CSMIG.*, TARGET CSMIG.*;
-TABLE CSMIG.*;
+MAP EAGLEEYE.*, TARGET EAGLEEYE.*;
-TABLE EAGLEEYE.*;
+MAP FBIAGENT.*, TARGET FBIAGENT.*;
-TABLE FBIAGENT.*;
+MAP GATEKEEPER.*, TARGET GATEKEEPER.*;
-TABLE GATEKEEPER.*;
+MAP GATEKEEPERADMIN.*, TARGET GATEKEEPERADMIN.*;
-TABLE GATEKEEPERADMIN.*;
+MAP GKREAD.*, TARGET GKREAD.*;
-TABLE GKREAD.*;
+MAP JIVETILREAD.*, TARGET JIVETILREAD.*;
-TABLE JIVETILREAD.*;
+MAP JOBMANAGER.*, TARGET JOBMANAGER.*;
-TABLE JOBMANAGER.*;
+MAP LEGAL.*, TARGET LEGAL.*;
-TABLE LEGAL.*;
+MAP MAILREAD.*, TARGET MAILREAD.*;
-TABLE MAILREAD.*;
+MAP MOFEEDS.*, TARGET MOFEEDS.*;
-TABLE MOFEEDS.*;
+MAP MOLAPP.*, TARGET MOLAPP.*;
-TABLE MOLAPP.*;
+MAP MOLEM.*, TARGET MOLEM.*;
-TABLE MOLEM.*;
+MAP MOLSUPP.*, TARGET MOLSUPP.*;
-TABLE MOLSUPP.*;
+MAP MOUSER.*, TARGET MOUSER.*;
-TABLE MOUSER.*;
+MAP RCREAD.*, TARGET RCREAD.*;
-TABLE RCREAD.*;
+MAP RCUSER.*, TARGET RCUSER.*;
-TABLE RCUSER.*;
+MAP REGREAD.*, TARGET REGREAD.*;
-TABLE REGREAD.*;
+MAP SCHOOL.*, TARGET SCHOOL.*;
-TABLE SCHOOL.*;
+MAP TILDUMMY.*, TARGET TILDUMMY.*;
-TABLE TILDUMMY.*;
+MAP TIMBOARDS.*, TARGET TIMBOARDS.*;
-TABLE TIMBOARDS.*;
+MAP TIMDEBATE.*, TARGET TIMDEBATE.*;
-TABLE TIMDEBATE.*;
+MAP TRAVELMAIL.*, TARGET TRAVELMAIL.*;
-TABLE TRAVELMAIL.*;</code>
+</code>