PeopleSoft: Export Tools tables prior to a refresh HRDBUG

 set output O:\Users\GM15\HRDBUGbeforeRefresh.dat;

set log O:\Users\GM15\HRDBUGbeforeRefresh.LOG;


--Search Table

export PS_PTSF_SRCH_ENGN;


--URL Definitions and PSOPTIONS

export PSURLDEFN;

export PSOPTIONS;


--PRCS Defn and Report Node Tables

export PS_CDM_DIST_NODE;

export PS_SERVERDEFN;

export PSSERVERSTAT;

export PS_SERVERCLASS;

export PS_SERVEROPRTN;

export PS_SERVERACTVTY;

export PS_SERVERNOTIFY;

export PS_SERVERPURGLIST;

export PS_SERVERMESSAGE;


--Integration Broker Setup Tables

export PSCONNPROP;

export PSMSGNODEDEFN;

export PSNODEDEFNLANG;

export PSCONNECTSTRING;

export PSNODEURITEXT;

export PSNODECONPROP;

export PSNODEPROP;

export PSNODESDOWN;

export PSTRUSTNODES;

export PSURLDEFN;

export PSIBLOADBALURL;

export PSIBGATEWAYURLS;

export PSAPMSGDOMSTAT;

export PSAPMSGDSPSTAT;

export PSIBPROFILE;

export PSIBFAILOVER;

export PSGATEWAY;

export PSIBSVCSETUP;

export PSOPERATION;

export PSOPERATIONURI;

export PSIBRTNGDEFN;

export PSRTNGDFNCONPRP;

export PSRTNGDFNPROP;

export PSIBRTNGSUBDEFN;

export PSRTNGDFNPARM;

export PSOPRHDLR;

export PSOPERATIONAC;

export PSOPERATIONAE;

export PSOPERATIONCI;

export PSOPERATIONDMS;

export PSIBLBURLS;

export PSIBWSDLDFN;

export PSIBWSDLDATA;

export PSQUEUEPART;

export PSCONN;


--Web Profile Tables

export PSWEBPROFHIST;

export PSWEBPROFILE;

export PSWEBPROFNVP;

export PSWEBPROFBROW;

export PSWEBPROFCOOK;

export PSWEBPROFDEF;

export PSWEBPROFPROP;


Comments

Popular posts from this blog

Postgres: Clean up stopped replication slot