DB Wiki

EXTRACT DPMOL01
SETENV (NLS_LANG="ENGLISH_UNITED KINGDOM.WE8ISO8859P1")
USERID ggate@andracaa, PASSWORD password

RMTHOST 10.250.135.168, mgrport 7809, compress, tcpbufsize 262144, tcpflushbytes 262144
RMTTRAIL ./dirdat/target/ml, format release 11.2
PASSTHRU
TABLE MAILONLINE.*;

EXTRACT DPRDC01
SETENV (NLS_LANG="ENGLISH_UNITED KINGDOM.WE8ISO8859P1")
USERID ggate@andracaa, PASSWORD password

RMTHOST 10.250.135.168, mgrport 7809, compress, tcpbufsize 262144, tcpflushbytes 262144
RMTTRAIL ./dirdat/target/rc, format release 11.2
PASSTHRU
TABLE RDRCOMMENTS.*;

EXTRACT DPREG01
SETENV (NLS_LANG="ENGLISH_UNITED KINGDOM.WE8ISO8859P1")
USERID ggate@andracaa, PASSWORD password

RMTHOST 10.250.135.168, mgrport 7809, compress, tcpbufsize 262144, tcpflushbytes 262144
RMTTRAIL ./dirdat/target/rg, format release 11.2
PASSTHRU
TABLE REGISTRATION.*;

Check the list of schemas below to ensure that there have been no new schemas created recently.

EXTRACT DPOTH01
SETENV (NLS_LANG="ENGLISH_UNITED KINGDOM.WE8ISO8859P1")
USERID ggate@andracaa, PASSWORD password

RMTHOST 10.250.135.168, mgrport 7809, compress, tcpbufsize 262144, tcpflushbytes 262144
RMTTRAIL ./dirdat/target/ot, format release 11.2

PASSTHRU
TABLE EAGLEEYE.*;
TABLE TRAVELMAIL.*;
TABLE TILDUMMY.*;
TABLE SCHOOL.*;
TABLE CLEARSPACE.*;
TABLE CSMIG.*;
TABLE GATEKEEPER.*;
TABLE GATEKEEPERADMIN.*;
TABLE TIMBOARDS.*;
TABLE BOARDSMIG.*;
TABLE APTECO.*;
TABLE GKREAD.*;
TABLE MAILREAD.*;
TABLE ANDCOMMUNITIES.*;
TABLE JIVETILREAD.*;
TABLE MOFEEDS.*;
TABLE MOUSER.*;
TABLE MOLAPP.*;
TABLE TIMDEBATE.*;
TABLE JOBMANAGER.*;
TABLE ANALYTICS.*;
TABLE RCREAD.*;
TABLE REGREAD.*;
TABLE MOLEM.*;
TABLE MOLSUPP.*;
TABLE RCUSER.*;
TABLE LEGAL.*;
TABLE FBIAGENT.*;