Differences

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

--- extract10g [2016/10/21 09:02] – created z0hpvk
+++ extract10g [2025/03/08 22:24] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
+===== Extract Parameters for 10g =====
+==== MailOnline Schema ====
 <code>EXTRACT EXTMOL01
 SETENV (NLS_LANG="ENGLISH_UNITED KINGDOM.WE8ISO8859P1")
@@ Line 40: / Line 43: @@
 TABLE MAILONLINE.QRTZ_FIRED_TRIGGERS, GETBEFORECOLS (ON DELETE KEY);
-TABLE MAILONLINE.QRTZ_SCHEDULER_STATE, GETBEFORECOLS (ON UPDATE ALL, ON DELETE ALL);
+TABLE MAILONLINE.QRTZ_SCHEDULER_STATE,
+      GETBEFORECOLS (ON UPDATE ALL, ON DELETE ALL);
 TABLE MAILONLINE.ARTICLES_VERSIONS,
@@ Line 59: / Line 63: @@
 TABLE MAILONLINE.*;
 </code>
+==== Reader Comments Schema ====
+<code>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.*;</code>
+==== Registration Schema ====
+<code>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.*;
+</code>
+==== Other Schemas ====
+Check the list of schemas below to ensure that there have been no new schemas created recently.
+<code>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
+EXTTRAIL ./dirdat/source/ot
+NODYNAMICRESOLUTION
+TABLE FBIAGENT.ARTICLE, GETBEFORECOLS (ON UPDATE ALL);
+DYNAMICRESOLUTION
+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.*;</code>