Differences

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

--- extract10g [2016/10/21 09:06] – [MailOnline Schema] z0hpvk
+++ extract10g [2025/03/08 22:24] (current) – external edit 127.0.0.1
@@ Line 110: / Line 110: @@
 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>