=========================================================================
PSOFT : Tools delivered Import/Export dms scripts
# Version : PT8.5x
cd $PS_HOME/scripts
--------------------------------------------------------------------------------------------------------------
To import & export all User Profiles
1. userimport.dms
2. userexport.dms
This script looks like below and contains these are User Profile Tables:
SET OUTPUT USEREXPORT.DAT;
SET LOG USEREXPORT.LOG;
-- USERS
EXPORT PSOPRDEFN;
EXPORT PSOPRALIAS;
EXPORT PSROLEUSER;
EXPORT PSUSERATTR;
EXPORT PSUSEREMAIL;
EXPORT PSUSERPRSNLOPTN;
EXPORT PS_ROLEXLATOPR;
EXPORT PS_RTE_CNTL_RUSER;
----------------------------------------------------------------------------
To import & export PeopleTools security tables
1. securityimport.dms
2. securityexport.dms
This script looks as below and these tables are Security Tables:
SET OUTPUT SECURITYEXPORT.DAT;
SET LOG SECURITYEXPORT.LOG;
-- ACCESS PROFILES
EXPORT PSACCESSPRFL;
-- USERS
EXPORT PSOPRDEFN;
EXPORT PSOPRALIAS;
EXPORT PSROLEUSER;
EXPORT PSUSERATTR;
EXPORT PSUSEREMAIL;
EXPORT PSUSERPRSNLOPTN;
EXPORT PS_ROLEXLATOPR;
EXPORT PS_RTE_CNTL_RUSER;
-- ROLES
EXPORT PSROLEDEFN;
EXPORT PSROLEDEFNLANG;
EXPORT PSROLECANGRANT;
EXPORT PSROLECLASS;
-- PERMISSION LISTS
EXPORT PSCLASSDEFN;
EXPORT PSAUTHBUSCOMP;
EXPORT PSAUTHCHNLMON;
EXPORT PSAUTHCUBE;
EXPORT PSAUTHITEM;
EXPORT PSAUTHOPTN;
EXPORT PSAUTHPRCS;
EXPORT PSAUTHSIGNON;
EXPORT PSPRCSPRFL;
EXPORT PS_MC_OPR_SECURITY;
EXPORT PS_MC_OPRID;
EXPORT PS_SCRTY_ACC_GRP;
EXPORT PS_SCRTY_QUERY;
-- DEFINITION SECURITY
EXPORT PSOBJGROUP;
EXPORT PSOPROBJ;
-- PERSONALIZATIONS
EXPORT PSUSEROPTNDEFN;
EXPORT PSUSEROPTNLANG;
EXPORT PSOPTNCATGRPLNG;
EXPORT PSOPTNCATGRPTBL;
EXPORT PSOPTNCATTBL;
EXPORT PSOPTNCATLANG;
-- SECURITY OPTIONS
EXPORT PSSECOPTIONS;
-- SECURITY LINKS
EXPORT PSUSEROTHER;
EXPORT PSUSERSELFOTHER;
EXPORT PSROLEOTHER;
EXPORT PSPERMLISTOTHER;
-- USER ID TYPES
EXPORT PSOPRALIASTYPE;
EXPORT PSOPRALIASFIELD;
-- DELETE USER BYPASS TABLE
EXPORT PS_BYPASS_TABLE;
-- FORGOT EMAIL TEXT
EXPORT PSPSWDEMAIL;
-- PASSWORD HINTS
EXPORT PSPSWDHINT;
-- SIGNON PEOPLECODE
EXPORT PSSIGNONPPC;
-- DIRECTORY
EXPORT PSDSDIR;
EXPORT PSDSSRVR;
EXPORT DSCONNECTID;
EXPORT PSDSEXT_INSTALL;
EXPORT PSDSSECMAPMAIN;
EXPORT PSDSSECMAPSRVR;
EXPORT DSUSRPRFLMAP;
EXPORT PSDSUSERPRFL;
EXPORT PSDSSECROLERULE;
EXPORT DSSRCH_SBR;
EXPORT DSSRCHATTR;
EXPORT DSSECFILTER;
EXPORT PT_WF_NOT_DSCFG;
-----------------------------------------------------------------------------
To import & export only PeopleTools tables i.e. No application data
1. mvprdimp.dms
2. mvprdexp.dms
This script looks like below and these Tables are PeopleTools Tables:
SET LOG MVPRDEXP1.LOG
SET OUTPUT MVPRDP1.DAT;
EXPORT PSACCESSPRFL;
EXPORT PSOPRDEFN;
EXPORT PSSTATUS;
SET LOG MVPRDEXP2.LOG;
SET OUTPUT MVPRD2.DAT;
-- PEOPLETOOLS PROJECTS
EXPORT PSPROJECTDEFN WHERE PROJECTNAME LIKE 'PPL%' or PROJECTNAME LIKE 'PT84%';
EXPORT PSPROJECTITEM WHERE PROJECTNAME LIKE 'PPL%' or PROJECTNAME LIKE 'PT84%';
EXPORT PSPROJDEFNLANG WHERE PROJECTNAME LIKE 'PPL%' or PROJECTNAME LIKE 'PT84%';
EXPORT PSPROJECTDEP WHERE PROJECTNAME LIKE 'PPL%' or PROJECTNAME LIKE 'PT84%';
EXPORT PSPROJECTINC WHERE PROJECTNAME LIKE 'PPL%' or PROJECTNAME LIKE 'PT84%';
EXPORT PSPROJECTMSG WHERE PROJECTNAME LIKE 'PPL%' or PROJECTNAME LIKE 'PT84%';
EXPORT PSPROJECTSEC WHERE PROJECTNAME LIKE 'PPL%' or PROJECTNAME LIKE 'PT84%';
SET LOG MVPRDEXP3.LOG;
SET OUTPUT MVPRD3.DAT;
-- SYSTEM
EXPORT PSOPTIONS;
-- RECORDS AND INDEXES
EXPORT PSRECDEFN;
EXPORT PSRECDEFNLANG;
EXPORT PSRECFIELD;
EXPORT PSINDEXDEFN;
EXPORT PSKEYDEFN;
EXPORT PSDDLMODEL;
EXPORT PSDDLDEFPARMS;
EXPORT PSSPCDDLPARM;
EXPORT PSRECDDLPARM;
EXPORT PSIDXDDLPARM;
EXPORT PSRECFIELDDB;
EXPORT PSRECTBLSPC;
-- FIELDS
EXPORT PSDBFIELD;
EXPORT PSDBFIELDLANG;
EXPORT PSDBFLDLABL;
EXPORT PSDBFLDLABLLANG;
-- FIELD FORMATS
EXPORT PSFMTDEFN;
EXPORT PSFMTITEM;
-- TRANSLATES
EXPORT PSXLATDEFN;
EXPORT PSXLATITEM;
EXPORT PSXLATITEMLANG;
-- PAGES
EXPORT PSPNLDEFN;
EXPORT PSPNLDEFNLANG;
EXPORT PSPNLFIELD;
EXPORT PSPNLFIELDLANG;
EXPORT PSPNLFIELDEXT;
EXPORT PSPNLACTIVEX;
EXPORT PSPNLHTMLAREA;
EXPORT PSPNLHTMLLANG;
EXPORT PSPNLCNTRLDATA;
EXPORT PSPNLCTLDATALNG;
EXPORT PSPNLBTNDATA;
EXPORT PSPNLBTNLANG;
EXPORT PSPNLTREECTRL;
EXPORT PSPTPNLRTEDITOR;
-- MENUS
EXPORT PSMENUDEFN;
EXPORT PSMENUDEFNLANG;
EXPORT PSMENUITEM;
EXPORT PSMENUITEMLANG;
EXPORT PSXFERITEM;
-- PANEL GROUPS
EXPORT PSPNLGRPDEFN;
EXPORT PSPNLGRPDEFNEXT;
EXPORT PSPNLGDEFNLANG;
EXPORT PSPNLGROUP;
EXPORT PSPNLGROUPLANG;
-- PEOPLECODE
EXPORT PSPCMPROG;
EXPORT PSPCMNAME;
EXPORT PSPCMSYNCID;
EXPORT PSPCMTXT;
-- QUERIES
EXPORT PSQRYDEFN;
EXPORT PSQRYDEFNLANG;
EXPORT PSQRYBIND;
EXPORT PSQRYBINDLANG;
EXPORT PSQRYCRITERIA;
EXPORT PSQRYEXPR;
EXPORT PSQRYFIELD;
EXPORT PSQRYFIELDLANG;
EXPORT PSQRYFLAGS;
EXPORT PSQRYLINK;
EXPORT PSQRYRECORD;
EXPORT PSQRYSELECT;
-- TREE STRUCTURES
EXPORT PSTREESTRCT;
EXPORT PSTREESTRCTLANG;
-- TREES
EXPORT PSTREEDEFN;
EXPORT PSTREEDEFNLANG;
EXPORT PSTREEBRANCH;
EXPORT PSTREELEAF;
EXPORT PSTREELEVEL;
EXPORT PSTREENODE;
EXPORT PSTREEPROMPT;
EXPORT PSTREESELCTL;
EXPORT PSTREESELNUM;
EXPORT PSTREESELECT01;
EXPORT PSTREESELECT02;
EXPORT PSTREESELECT03;
EXPORT PSTREESELECT04;
EXPORT PSTREESELECT05;
EXPORT PSTREESELECT06;
EXPORT PSTREESELECT07;
EXPORT PSTREESELECT08;
EXPORT PSTREESELECT09;
EXPORT PSTREESELECT10;
EXPORT PSTREESELECT11;
EXPORT PSTREESELECT12;
EXPORT PSTREESELECT13;
EXPORT PSTREESELECT14;
EXPORT PSTREESELECT15;
EXPORT PSTREESELECT16;
EXPORT PSTREESELECT17;
EXPORT PSTREESELECT18;
EXPORT PSTREESELECT19;
EXPORT PSTREESELECT20;
EXPORT PSTREESELECT21;
EXPORT PSTREESELECT22;
EXPORT PSTREESELECT23;
EXPORT PSTREESELECT24;
EXPORT PSTREESELECT25;
EXPORT PSTREESELECT26;
EXPORT PSTREESELECT27;
EXPORT PSTREESELECT28;
EXPORT PSTREESELECT29;
EXPORT PSTREESELECT30;
-- ACCESS GROUPS
EXPORT ACCESS_GRP_TBL;
EXPORT ACCESS_GRP_LANG;
-- COLORS
EXPORT PSCOLORDEFN;
-- STYLES
EXPORT PSSTYLEDEFN;
EXPORT PSSTYLEDEFNLANG;
-- BUSINESS PROCESSES
EXPORT PSBUSPROCDEFN;
EXPORT PSBUSPROCITEM;
EXPORT PSBUSPROCLANG;
EXPORT PSBUSPROCSEC;
EXPORT PSBUSPRIMG;
EXPORT PSBUSPITEMIMG;
EXPORT PSBUSPITEMLANG;
EXPORT PSBUSPRIMGLANG;
-- ACTIVITIES
EXPORT PSACTIVITYDEFN;
EXPORT PSACTIVITYLANG;
EXPORT PSACTIVIMG;
EXPORT PSACTIVIMGLANG;
EXPORT PSSTEPDEFN;
EXPORT PSEVENTDEFN;
EXPORT PSEVENTROUTE;
EXPORT PSMSGAGTDEFN;
EXPORT PSMAPEXPR;
EXPORT PSMAPFIELD;
EXPORT PSMAPLEVEL;
EXPORT PSMAPRECFIELD;
EXPORT PSMAPROLEBIND;
EXPORT PSMAPROLENAME;
-- PROCESS DEFINITIONS
EXPORT PRCSDEFN;
EXPORT PRCSDEFNLANG;
EXPORT PRCSDEFNGRP;
EXPORT PRCSDEFNPNL;
EXPORT PRCSDEFNXFER;
EXPORT PRCSDEFNNOTIFY;
EXPORT PRCSDEFNCNTDIST;
EXPORT PRCSDEFNMESSAGE;
EXPORT PRCSDEFNMETA;
EXPORT PS_PRCSDEFNURL;
EXPORT PS_PRCSDEFNURL_LNG;
EXPORT PS_PRCSDEFNURLKEY;
EXPORT PS_PRCS_RUNPARM;
-- PROCESS SERVERS
EXPORT PS_SERVERCLASS;
EXPORT PS_SERVERDEFN;
EXPORT PS_SERVERDEFN_LNG;
EXPORT PS_SERVERNOTIFY;
EXPORT PS_SERVERMESSAGE;
EXPORT PS_SERVEROPRTN;
EXPORT PS_SERVERCATEGORY;
-- PROCESS TYPES
EXPORT PS_PRCSTYPEDEFN;
EXPORT PS_PRCSTYPEDEFNLNG;
EXPORT PS_PRCSTYPEMETA;
-- PROCESS JOBS
EXPORT PRCSJOBDEFN;
EXPORT PRCSJOBDEFNLANG;
EXPORT PRCSJOBGRP;
EXPORT PRCSJOBITEM;
EXPORT PRCSJOBPNL;
EXPORT PS_PRCSJOBNOTIFY;
EXPORT PS_PRCSJOBCNTDIST;
EXPORT PS_PRCSJOBMESSAGE;
EXPORT PS_PRCSOUTPUTLIST;
EXPORT PS_PRCSOUTDESTTYPE;
EXPORT PS_PRCSSYSTEM;
EXPORT PS_PRCSPURGELIST;
EXPORT PS_PRCS_CAT_TBL;
EXPORT PS_PRCS_CAT_LG_TBL;
-- PROCESS RECURRENCE
EXPORT PRCSRECUR;
EXPORT PRCSRECURLANG;
EXPORT PRCSRECURDATE;
EXPORT PRCSRECUREXEMPT;
-- PROCESS CONTROL
EXPORT PS_SCHDLDEFN;
EXPORT PS_SCHDLDEFNLANG;
EXPORT PS_SCHDLITEM;
EXPORT PS_SCHDLMESSAGE;
EXPORT PS_SCHDLNODEPARM;
EXPORT PS_SCHDLNOTIFY;
EXPORT PS_SCHDLRPTDIST;
EXPORT PS_SCHDLTEXT;
-- DIMENSIONS
EXPORT DIMENSION;
EXPORT DIMENSION_LANG;
EXPORT DIM_CTRL_TBL;
EXPORT DIM_DATA_SRC;
EXPORT DIM_INPUT_FLD;
EXPORT DIM_ROLLUP;
EXPORT DIM_ROLLUP_LVL;
-- ANALYSIS MODELS
EXPORT ANALYSIS_MODEL;
EXPORT ANL_MOD_DAT_SRC;
EXPORT ANL_MOD_DIM;
EXPORT ANL_MOD_DIM_FLD;
-- CUBE TEMPLATES
EXPORT ANALYSIS_DB;
EXPORT ANALYSIS_DB_DIM;
EXPORT ANL_DB_LANG;
EXPORT ANL_DB_QRY_ESS;
EXPORT CUBE_AGG_DEF;
EXPORT CUBE_AGG_DIM;
EXPORT CUBE_FILTER_ITM;
-- BUSINESS INTERLINKS
EXPORT PSIODEFN;
EXPORT PSIODEFNLANG;
EXPORT PSIOINPUTS;
EXPORT PSIOOUTPUTS;
EXPORT PSIOSETTINGS;
-- SQL
EXPORT PSSQLDEFN;
EXPORT PSSQLDESCR;
EXPORT PSSQLHASH;
EXPORT PSSQLLANG;
EXPORT PSSQLTEXTDEFN;
-- FILE LAYOUT DEFINITIONS
EXPORT PSFLDDEFN;
EXPORT PSFLDFIELDDEFN;
EXPORT PSFLDSEGDEFN;
-- BUSINESS COMPONENTS
EXPORT PSBCDEFN;
EXPORT PSBCDEFNLANG;
EXPORT PSBCITEM;
EXPORT PSBCITEMLANG;
-- APP ENGINE PROGRAMS
EXPORT PSAEAPPLDEFN;
EXPORT PSAEAPPLLANG;
EXPORT PSAEAPPLSTATE;
EXPORT PSAEAPPLTEMPTBL;
-- APP ENGINE SECTIONS
EXPORT PSAESECTDEFN;
EXPORT PSAESECTDTLDEFN;
EXPORT PSAESTEPDEFN;
EXPORT PSAESTEPMSGDEFN;
EXPORT PSAESTMTDEFN;
EXPORT PS_AEINSTANCENBR;
EXPORT PS_AELOCKMGR;
-- MESSAGE NODES
EXPORT PSMSGNODEDEFN;
EXPORT PSNODEDEFNLANG;
EXPORT PSCONNECTSTRING;
EXPORT PSNODEURITEXT;
EXPORT PSNODECONPROP;
EXPORT PSNODCONPRPLANG;
EXPORT PSNODEPROP;
EXPORT PSNODEPROPLANG;
EXPORT PSNODESDOWN;
EXPORT PSTRUSTNODES;
-- MESSAGE CHANNELS
EXPORT PSCHNLDEFN;
EXPORT PSCHNLDEFNLANG;
EXPORT PSCHNLNODE;
EXPORT PSSUBCHNL;
-- MESSAGE DEFINITIONS
EXPORT PSMSGATTR;
EXPORT PSMSGDEFN;
EXPORT PSMSGDEFNLANG;
EXPORT PSMSGFLDOVR;
EXPORT PSMSGPARTS;
EXPORT PSMSGREC;
EXPORT PSMSGVER;
-- APPROVAL RULE SETS
EXPORT APPR_HDR_LNG;
EXPORT APPR_RULE_AMT;
EXPORT APPR_RULE_DETL;
EXPORT APPR_RULE_FIELD;
EXPORT APPR_RULE_HDR;
EXPORT APPR_RULE_LN;
EXPORT APPR_RULE_QTY;
EXPORT APPR_RULE_ROLE;
EXPORT PSVAITEM;
EXPORT PSVAITEMIMG;
EXPORT PSVAITEMLANG;
-- IMAGE AND HTMLCATALOG-- CONTENT
EXPORT PSCONTDEFN;
EXPORT PSCONTDEFNLANG;
EXPORT PSCONTENT;
EXPORT PSCONTENTLANG;
-- STYLE SHEETS
EXPORT PSSTYLECLASS;
EXPORT PSSTYLECLASSFNT;
EXPORT PSSTYLSHEETDEFN;
EXPORT PSSTYLECLSLANG;
EXPORT PSSTYLEFNTLANG;
EXPORT PSSTYLEDFNLANG;
-- LANGUAGES
EXPORT PSLANGUAGES;
EXPORT PS_STRINGS_TBL;
EXPORT PS_STRINGS_LNG_TBL;
-- SUBSCRIPTIONS
EXPORT PSSUBDEFN;
-- RECORD GROUP
EXPORT PS_REC_GROUP_REC;
EXPORT PS_REC_GROUP_TBL;
-- CHANGE CONTROL
EXPORT PSCHGCTLHIST;
EXPORT PSCHGCTLLOCK;
-- OBJECT CHANGE (RENAMES)
EXPORT PSOBJCHNG;
-- APP MESSAGING
EXPORT PSAPMSGARCHPC;
EXPORT PSAPMSGARCHPD;
EXPORT PSAPMSGARCHPH;
EXPORT PSAPMSGARCHSC;
EXPORT PSAPMSGARCHTMP;
EXPORT PSAPMSGPUBATTR;
EXPORT PSAPMSGPUBCERR;
EXPORT PSAPMSGPUBCERRP;
EXPORT PSAPMSGPUBCLOCK;
EXPORT PSAPMSGPUBCON;
EXPORT PSAPMSGPUBCSYNC;
EXPORT PSAPMSGPUBDATA;
EXPORT PSAPMSGPUBERR;
EXPORT PSAPMSGPUBERRP;
EXPORT PSAPMSGPUBHDR;
EXPORT PSAPMSGPUBINST;
EXPORT PSAPMSGPUBLOCK;
EXPORT PSAPMSGPUBSYNC;
EXPORT PSAPMSGSUBCERR;
EXPORT PSAPMSGSUBCERRP;
EXPORT PSAPMSGSUBCLOCK;
EXPORT PSAPMSGSUBCON;
EXPORT PSAPMSGSUBCSYNC;
EXPORT PSAPMSGSUBPRCID;
EXPORT PSAPMSGXTB;
-- URL DEFINITIONS
EXPORT PSURLDEFN;
EXPORT PSURLDEFNLANG;
-- PORTAL
EXPORT PSPRSMDEFN;
EXPORT PSPRSMDEFNLANG;
EXPORT PSPRSMATTR;
EXPORT PSPRSMATTRLANG;
EXPORT PSPRSMATTRVAL;
EXPORT PSPRSMATTRVALNG;
EXPORT PSPRSMPERM;
EXPORT PSPRSMSYSATTR;
EXPORT PSPRSMSYSATTRVL;
EXPORT PSPRSMHPASGPGLT;
EXPORT PSPRSMSYNC;
EXPORT PSPRDMDEFN;
EXPORT PSPRDMDEFNLANG;
EXPORT PSPRDMCNTPRV;
EXPORT PSPRUHPERSPGLT;
-- RELATIONSHIPS
EXPORT PSRELATCONTACT;
EXPORT PSRELATIONLANG;
EXPORT PSRELATIONPROP;
EXPORT PSRELATIONSHIP;
EXPORT PSRELPROPLANG;
-- APPLICATION PACKAGES
EXPORT PSPACKAGEDEFN;
EXPORT PSPACKAGELANG;
EXPORT PSAPPCLASSDEFN;
-- ARCHIVE TEMPLATES
EXPORT PS_ARCH_PROJ;
EXPORT PS_ARCH_TBL;
EXPORT PS_ARCH_CTRL;
EXPORT PS_ARCH_OTH_CTRL;
EXPORT PS_ARCH_SQL_LNG;
-- ARCHIVE OBJECTS
EXPORT PSARCHOBJDEFN;
EXPORT PSARCHOBJLANG;
EXPORT PSARCHOBJREC;
-- ARCHIVE TEMPLATES (TYPE 2)
EXPORT PSARCHTEMPLATE;
EXPORT PSARCHTEMPLANG;
EXPORT PSARCHTEMPOBJ;
EXPORT PSARCHTEMPQRY;
EXPORT PSARCHTEMPAE;
-- DIAGNOSTIC PLUGINS
EXPORT PSDIAGREG;
-- CONNECT STRINGS
EXPORT PSCONN;
EXPORT PSCONNLANG;
EXPORT PSCONNPROP;
EXPORT PSCONNPROPLANG;
-- FORMAT DEFINITIONS
EXPORT PSCIREF;
EXPORT PSCIREFLANG;
EXPORT PSCIREFPROPERTY;
EXPORT PSCIREFENUM;
EXPORT PSCISYNCDEFN;
-- EVALUATED NODE TRANSACTION
EXPORT PSNODETRX;
EXPORT PSNODTRXCONPROP;
-- EVALUATED RELATIONSHIP TRANSACTION
EXPORT PSRELATIONTRX;
-- MOBILE PAGE
EXPORT PSMPDEFN;
EXPORT PSMPDEFNLANG;
EXPORT PSMPDEFNDEV;
EXPORT PSMPDEFNDEVLANG;
EXPORT PSMPCONTDEV;
EXPORT PSMPCONTDEVLANG;
EXPORT PSSYSTEMID;
EXPORT PSAUTHMP;
-- DICTIONARY
EXPORT PSSCDICTDEFN;
-- MESSAGES
EXPORT PSMSGSETDEFN;
EXPORT PSMSGSETLANG;
EXPORT PSMSGCATDEFN;
EXPORT PSMSGCATLANG;
-- PROBLEM DEFINITIONS
EXPORT PSOPTPRBTYPE;
EXPORT PSOPTPRBTYPELNG;
EXPORT PSOPTTRN;
EXPORT PSOPTTRNLNG;
EXPORT PSOPTTRNCTLG;
EXPORT PSOPTREC;
EXPORT PSOPTRECLNG;
EXPORT PSOPTFIELD;
-- PORTAL REGISTRY USER FAVORITES
EXPORT PSPRUFDEFN;
-- PORTAL USER REGISTRY HOMEPAGE
EXPORT PSPRUHDEFN;
EXPORT PSPRUHTAB;
EXPORT PSPRUHTABPGLT;
-- SYSTEM PAUSE TIME
EXPORT PSSPTDEFN;
EXPORT PSSPTIMES;
-- TOOLBARS
EXPORT PSTOOLBARDEFN;
EXPORT PSTOOLBARITEM;
-- MAINTENANCE LOG
EXPORT PS_MAINTENANCE_LOG;
-- HOLIDAY DEFINITIONS
EXPORT PSHOLIDAYDEFN;
-- USERS
-- Note: PSOPRDEFN exported separately, see top of script
EXPORT PSOPRALIAS;
EXPORT PSROLEUSER;
EXPORT PSUSERATTR;
EXPORT PSUSEREMAIL;
EXPORT PSUSERPRSNLOPTN;
EXPORT PS_ROLEXLATOPR;
EXPORT PS_ROLEXLATOPR_LNG;
EXPORT PS_RTE_CNTL_RUSER;
-- ROLES
EXPORT PSROLEDEFN;
EXPORT PSROLEDEFNLANG;
EXPORT PSROLECANGRANT;
EXPORT PSROLECLASS;
-- PERMISSION LISTS
EXPORT PSCLASSDEFN;
EXPORT PSAUTHBUSCOMP;
EXPORT PSAUTHCHNLMON;
EXPORT PSAUTHCUBE;
EXPORT PSAUTHITEM;
EXPORT PSAUTHOPTN;
EXPORT PSAUTHQUEUEMON;
EXPORT PSAUTHPRCS;
EXPORT PSAUTHSIGNON;
EXPORT PSAUTHWS;
EXPORT PSPRCSPRFL;
EXPORT PS_MC_OPR_SECURITY;
EXPORT PS_MC_OPRID;
EXPORT PS_SCRTY_ACC_GRP;
EXPORT PS_SCRTY_QUERY;
-- DEFINITION SECURITY
EXPORT PSOBJGROUP;
EXPORT PSOPROBJ;
-- PERSONALIZATIONS
EXPORT PSUSEROPTNDEFN;
EXPORT PSUSEROPTNLANG;
EXPORT PSOPTNCATGRPLNG;
EXPORT PSOPTNCATGRPTBL;
EXPORT PSOPTNCATTBL;
EXPORT PSOPTNCATLANG;
-- SECURITY OPTIONS
EXPORT PSSECOPTIONS;
-- SECURITY LINKS
EXPORT PSUSEROTHER;
EXPORT PSUSERSELFOTHER;
EXPORT PSROLEOTHER;
EXPORT PSPERMLISTOTHER;
-- USER ID TYPES
EXPORT PSOPRALIASTYPE;
EXPORT PSOPRALIASFIELD;
-- DELETE USER BYPASS TABLE
EXPORT PS_BYPASS_TABLE;
-- FORGOT EMAIL TEXT
EXPORT PSPSWDEMAIL;
EXPORT PSPSWDEMAILLANG;
-- PASSWORD HINTS
EXPORT PSPSWDHINT;
EXPORT PSPSWDHINT_LANG;
-- SIGNON PEOPLECODE
EXPORT PSSIGNONPPC;
-- DIRECTORY
EXPORT PSDSDIR;
EXPORT PSDSSRVR;
EXPORT DSCONNECTID;
EXPORT PSDSEXT_INSTALL;
EXPORT PSDSSECMAPMAIN;
EXPORT PSDSSECMAPSRVR;
EXPORT DSUSRPRFLMAP;
EXPORT PSDSUSERPRFL;
EXPORT PSDSSECROLERULE;
EXPORT DSSRCH_SBR;
EXPORT DSSRCHATTR;
EXPORT DSSECFILTER;
EXPORT PT_WF_NOT_DSCFG;
-- PEOPLETOOLS SYSTEM DATA
EXPORT PSCRYPTALGCHAIN;
EXPORT PSCRYPTALGDEFN;
EXPORT PSCRYPTALGPARAM;
EXPORT PSCRYPTCHNDEFN;
EXPORT PSCRYPTDLLDEFN;
EXPORT PSCRYPTKEYSET;
EXPORT PSCRYPTPRFL;
EXPORT PSCRYPTPRFLPRM;
EXPORT PSTIMEZONE;
EXPORT PSTIMEZONELANG;
EXPORT PSDSTTIME;
EXPORT PSCHARSETS;
EXPORT PS_OLAP_ATTRIB_NAM;
EXPORT PS_VERTICAL_MARKET;
EXPORT PS_APP_DES_OBJECTS;
EXPORT PS_APP_DES_OBJ_PAR;
EXPORT PSPGEACCESSDESC;
EXPORT PSOBJSECDESC;
EXPORT PSOPTPARMTYPE;
EXPORT PSLOCALEDEFN;
EXPORT PSLOCALELANG;
EXPORT PSLOCALEOPTNDFN;
EXPORT PSLOCALEORDER;
EXPORT PSCOLLATIONS;
EXPORT PS_CDM_FILE_EXT;
EXPORT PS_AEONLINEINST;
EXPORT PS_WL_TEMPLATE_GEN;
EXPORT PS_WL_TEMPL_GEN_TK;
EXPORT PSGATEWAY;
EXPORT PSRF_FLIST_TBL;
EXPORT PSRF_FLIST_LANG;
EXPORT PSRF_FVIEW_TBL;
EXPORT PSRF_FVIEW_LANG;
EXPORT PS_DECIMAL_POS_TBL;
EXPORT PS_WL_TEMPL_GNTKLN;
EXPORT PSACTIVEXLIC;
EXPORT PS_APPDES_OBJ_PERM;
EXPORT PSXMLSIGNINST;
EXPORT PS_TS_REC_KEYFLDS;
EXPORT PS_TS_REC_TXTFLDS;
EXPORT PS_TS_RECORDS;
EXPORT PS_MCF_IM_SERVERS;
EXPORT PS_MCF_INSTALL;
EXPORT PS_MCFIMNETWORKS;
EXPORT PSMCFRENPERMS;
EXPORT PSMCFSYSTEM;
EXPORT PS_MCFUQTASKCFG;
EXPORT PS_PINGOPTIONS;
EXPORT PSVERITYLOCALE;
EXPORT PS_PTP_TABLE1;
EXPORT PS_PTP_TABLE2;
EXPORT PS_PT_CTI_SWITCH;
EXPORT PS_WF_INSTSTATUS;
EXPORT PSIBWSDLADMIN;
EXPORT PSRENNAMETOPIC;
EXPORT PSTRANSFRM_TST;
EXPORT PSSHADOWSEQ;
EXPORT PS_PTEXEC2RESOURCE;
EXPORT PS_PT_ORA_RESOURCE;
EXPORT PS_PTCS_HANDLER;
EXPORT PS_PTCS_PARAMETERS;
EXPORT PS_PTCS_PARAMSLANG;
EXPORT PS_PTCSSERVICEDEFN;
EXPORT PS_PTCSSRVDEFNLANG;
-- WEB Data
EXPORT PSWEBPROFBROW;
EXPORT PSWEBPROFCOOK;
EXPORT PSWEBPROFDEF;
EXPORT PSWEBPROFILE;
EXPORT PSWEBPROFPROP;
EXPORT PSWEBPROFNVP;
-- XML Service Info
EXPORT PS_XMLSERVICEINFO;
-- EDI OBJECTS
EXPORT PS_ECACTIONCDS;
EXPORT PS_ECACTIONS;
EXPORT PS_ECCVTPROFILE;
EXPORT PS_ECENTITYCDS;
EXPORT PS_ECEXTPARTNER;
EXPORT PS_ECEXTTPLINK;
EXPORT PS_ECGENERAL;
EXPORT PS_ECINMAPFILE;
EXPORT PS_ECINMAPFLD;
EXPORT PS_ECINMAPFLDCVT;
EXPORT PS_ECINMAPREC;
EXPORT PS_ECINMAPRECFLD;
EXPORT PS_ECINTLINK;
EXPORT PS_ECINTPARTNER;
EXPORT PS_ECMAPDEFN;
EXPORT PS_ECMAPPROFILE;
EXPORT PS_ECNAMES;
EXPORT PS_ECOUTMAPCVT;
EXPORT PS_ECOUTMAPFLD;
EXPORT PS_ECOUTMAPREC;
EXPORT PS_ECOUTMAPWHERE;
EXPORT PS_ECPRIEVENTCDS;
EXPORT PS_ECPRODFLTS;
EXPORT PS_ECPROMAP;
EXPORT PS_ECPROTRANS;
EXPORT PS_ECSECEVENTCDS;
EXPORT PS_ECTPALIAS;
EXPORT PS_ECTPCVT;
EXPORT PS_ECTPCVT_HDR;
EXPORT PS_ECTPCVT_LN;
EXPORT PS_ECTPPROFILE;
EXPORT PS_ECTRANS;
EXPORT PS_ECTRANSOPTION;
EXPORT PS_ECTRANSOPVAL;
-- SDK Data
EXPORT PS_SDK_AMORT_PREF;
EXPORT PS_SDK_BUS_EXP_DTL;
EXPORT PS_SDK_BUS_EXP_PER;
EXPORT PS_SDK_COMPANY_TBL;
EXPORT PS_SDK_COUNTRY_TBL;
EXPORT PS_SDK_CURR_CD_TBL;
EXPORT PS_SDK_DEPT_TBL;
EXPORT PS_SDK_EM_MAILLST;
EXPORT PS_SDK_EM_RCVMSGS;
EXPORT PS_SDK_EM_SNDEMAIL;
EXPORT PS_SDK_FILEUTL_AET;
EXPORT PS_SDK_INSTALL;
EXPORT PS_SDK_INTL_FLG_CD;
EXPORT PS_SDK_JOB;
EXPORT PS_SDK_LOCH_TBL;
EXPORT PS_SDK_PERS_DATA;
EXPORT PS_SDK_POS_DATA;
EXPORT PS_SDK_PSTREENODE;
EXPORT PS_SDK_RP_INPUT;
EXPORT PS_SDK_RP_PO;
EXPORT PS_SDK_RP_POLINE;
EXPORT PS_SDK_RP_QUERYWRK;
EXPORT PS_SDK_RP_RESULT;
EXPORT PS_SDK_RP_SALORDER;
EXPORT PS_SDK_RP_SITE;
EXPORT PS_SDK_RP_SOQRY1;
EXPORT PS_SDK_RP_SOQRY2;
EXPORT PS_SDK_RT_TYPE_TBL;
EXPORT PS_SDK_RUNCNTL;
EXPORT PS_SDK_SCRTY_DEPT;
EXPORT PS_SDK_SM;
EXPORT PS_SDK_SM_CONCATE;
EXPORT PS_SDK_SRCHSPREF;
EXPORT PS_SDK_SRCH_SAVE;
EXPORT PS_SDK_STOCK;
EXPORT PS_SDK_STOCKXCHG;
EXPORT PS_SDK_STOCK_PRF;
EXPORT PS_SDK_UPS_COST;
EXPORT PS_SDK_UPS_CST_RES;
EXPORT PS_SDK_UPS_TIME;
-- Performance Monitor Data
EXPORT PSPMCONTEXTDEFN;
EXPORT PSPMEVENTDEFN;
EXPORT PSPMEVENTSET;
EXPORT PSPMMETRICDEFN;
EXPORT PSPMMETRICVALUE;
EXPORT PSPMMONITORGBL;
EXPORT PSPMSYSDEFAULTS;
EXPORT PSPMTABLEMAP;
EXPORT PSPMTRANSDEFN;
EXPORT PSPMTRANSSET;
EXPORT PSPMTRANSSET_LN;
-- Feed Data
EXPORT PS_PTFP_ATTRS;
EXPORT PS_PTFP_ATTRS_LANG;
EXPORT PS_PTFP_CATEGORY;
EXPORT PS_PTFP_CATG_LANG;
EXPORT PS_PTFP_DATATYPE;
EXPORT PS_PTFP_DTYPE_LANG
EXPORT PS_PTFP_DTYPE_IBSO;
EXPORT PS_PTFP_DTYPE_ATTR;
EXPORT PS_PTFP_DATTR_LANG
EXPORT PS_PTFP_FEED;
EXPORT PS_PTFP_FEED_LANG;
EXPORT PS_PTFP_OPTIONS;
EXPORT PS_PTFP_PARMS;
EXPORT PS_PTFP_PARMS_LANG;
EXPORT PS_PTFP_PUB_SITES;
EXPORT PS_PTFP_PVALS;
EXPORT PS_PTFP_PVALS_LANG;
EXPORT PS_PTFP_SECURITY;
EXPORT PS_PTFP_SETTINGS;
EXPORT PS_PTFP_SYSVAR;
-- Mathematical Model
EXPORT PSANALYTICREG;
EXPORT PSOPTCONARRAY;
EXPORT PSOPTCONSEXP;
EXPORT PSOPTINDEX;
EXPORT PSOPTINDEXSET;
EXPORT PSOPTLINEXP;
EXPORT PSOPTMODEL;
EXPORT PSOPTMODELLNG;
EXPORT PSOPTMDLSLVR;
EXPORT PSOPTOBJECTIVE;
EXPORT PSOPTPARARRAY;
EXPORT PSOPTPARAEXPDIM;
EXPORT PSOPTPARSDIM;
EXPORT PSOPTPRED;
EXPORT PSOPTPREDDIM;
EXPORT PSOPTPTMODEL;
EXPORT PSOPTREGION;
EXPORT PSOPTREGIONDIM;
EXPORT PSOPTSETDIM;
EXPORT PSOPTSLICEDIM;
EXPORT PSOPTSLICESET;
EXPORT PSOPTSOLVERPARA;
EXPORT PSOPTVAREXPDIM;
EXPORT PSOPTVARARRAY;
EXPORT PSOPTVARSDIM;
-- File Reference
EXPORT PSFILEREDEFN;
-- File Reference Type code
EXPORT PSTYPECODEDEFN;
-- ACE
EXPORT PSACECUBE;
EXPORT PSACECUBECOLL;
EXPORT PSACECUBECOLMAP;
EXPORT PSACECUBEDIMS;
EXPORT PSACEDIM;
EXPORT PSACEEXPDIMS;
EXPORT PSACEEXPSET;
EXPORT PSACEMDLDEFN;
EXPORT PSACEMDLDEFNLNG;
EXPORT PSACEORGANIZER;
EXPORT PSACEORGMAP;
EXPORT PSACERULE;
EXPORT PSACETREE;
EXPORT PSACEUSRFUNC;
EXPORT PSPNLACEGRDAXIS;
EXPORT PSPNLACEGRDDATA;
-- Web Services for Remote Portlets
EXPORT PSPRSMWSRPCONS;
EXPORT PSPRSMWSRPPROD;
EXPORT PSWSRPCPHDEFN;
EXPORT PSWSRPPLTDEFN;
EXPORT PSWSRPPLTGRPID;
EXPORT PSWSRPPLTKW;
EXPORT PSWSRPPLTKWLANG;
EXPORT PSWSRPPLTLANG;
EXPORT PSWSRPPRDDEFN;
EXPORT PSWSRPPRDLANG;
EXPORT PSWSRPPRDPROP;
-- Java Portlet User Preferences
EXPORT PSJPUPDEFN;
EXPORT PSJPUPPREF;
EXPORT PSJPUPPREFVAL;
-- Services
EXPORT PSSERVICE;
EXPORT PSSERVICELANG;
EXPORT PSSERVICEOPR;
EXPORT PSSERVICEUDDI;
-- Service Operation
EXPORT PSOPERATION;
EXPORT PSOPERATIONLANG;
-- Service Operation Routings
EXPORT PSIBRTNGDEFN;
EXPORT PSRTNGDFNLANG;
EXPORT PSRTNGDFNCONPRP;
EXPORT PSRTNGDFNPROP;
EXPORT PSRTNGDFNPROPLG;
EXPORT PSIBRTNGSUBDEFN;
EXPORT PSRTNGDFNPARM;
-- Service Operation Handlers
EXPORT PSOPRHDLR;
EXPORT PSOPRHDLRLANG;
EXPORT PSOPERATIONAC;
EXPORT PSOPERATIONAE;
EXPORT PSOPERATIONCI;
EXPORT PSOPERATIONDMS;
-- Service Operation Versions
EXPORT PSOPRVERDFN;
EXPORT PSOPRVERDFNLANG;
EXPORT PSOPRVERDFNPARM;
EXPORT PSOPRVERQUEPARM;
EXPORT PSOPRGENRTGPARM;
-- Integration Broker Queues
EXPORT PSQUEUEDEFN;
EXPORT PSIBQUEUEINST;
EXPORT PSQUEUEDEFNLANG;
EXPORT PSQUEUEOVRD;
EXPORT PSQUEUEPART;
-- XML Publisher Data Source
EXPORT PSXPDATASRC;
EXPORT PSXPDATASRCLNG;
EXPORT PSXPSCHEMAFLMN;
EXPORT PSXPSMPLDTMN;
-- XML Publisher File Definition
EXPORT PSFILEDEFN;
EXPORT PSFILEDATA;
-- XML Publisher Report Definition
EXPORT PSXPRPTDEFN;
EXPORT PSXPRPTDEFNLNG;
EXPORT PSXPRPTOUTFMT;
EXPORT PSXPRPTPROP;
EXPORT PSXPRPTSCOPEFLD;
EXPORT PSXPRPTSRCHKEYS;
EXPORT PSXPRPTTMPL;
EXPORT PSXPRPTTMPLCTRL;
EXPORT PSXPRPTVIEWER;
-- XML Publisher Template Definition
EXPORT PSXPTMPLDEFN;
EXPORT PSXPTMPLDEFNLNG;
EXPORT PSXPTMPLFILEDEF;
EXPORT PSXPTMPLTRINFO;
-- Integration Broker Schema
EXPORT PSIBSCMADFN;
EXPORT PSIBSCMADATA;
-- Integration Broker WSDL
EXPORT PSIBWSDLDFN;
EXPORT PSIBWSDLDATA;
-- CONNECTED QUERY
EXPORT PSCONQRSDEFN;
EXPORT PSCONQRSDEFNLAN;
EXPORT PSCONQRSFLDREL;
EXPORT PSCONQRSMAP;
EXPORT PSCONQRSPROP;
-- Document Schema
EXPORT PSDOCSCMADFN;
EXPORT PSDOCSCMADATA;
-- Document Logical Schema
EXPORT PSLSDEFN;
EXPORT PSLSDEFNBODY;
EXPORT PSLSDEFNLANG;
-- Document Logical Dependency
EXPORT PSLSDEPDEFN;
EXPORT PSLSDEPDEFNLANG;
EXPORT PSLSDEPCHLDDFN;
-- Document Physical Schema
EXPORT PSPHYSSCHDEFN;
EXPORT PSPHYSSCHLANG;
EXPORT PSPHYSSCHBODY;
-- Cube Dimension
EXPORT PSCUBDIMENSION;
EXPORT PSCUBATTRIBDIM;
EXPORT PSCUBDIMENGEN;
EXPORT PSCUBDIMENLANG;
EXPORT PSCUBDIMSTRINFO;
EXPORT PSCUBDIMSTRUCT;
-- Cube Outline
EXPORT PSCUBOUTLINE;
EXPORT PSCUBDIMLIST;
EXPORT PSCUBOUTLINLANG;
EXPORT PSCUBOUTQRY;
EXPORT PSCUBOUTQRYCOL;
EXPORT PSCUBOUTQRYINF;
-- Cube Connection
EXPORT PSCUBCONNECTID;
EXPORT PSCUBCONNLANG;
-- Cube Template
EXPORT PSCUBTEMPL;
EXPORT PSCUBTEMPL_LNG;
-- Certificate
EXPORT PSCERTDB;
EXPORT PSCERTDEFN;
EXPORT PSCERTDEFNDEL;
EXPORT PSCERTISSUER;
-- Key
EXPORT PSKEYDB;
EXPORT PSKEYDBDEL;
-- Test
EXPORT PSPTTSTDEFN;
EXPORT PSPTTSTCOMMAND;
EXPORT PSPTTSTERROR;
-- Test Case
EXPORT PSPTTSTCASE;
EXPORT PSPTTSTCASEVAL;
-- Application Data Set
EXPORT PSADSDEFAULTS;
EXPORT PSADSEXCLUSIONS;
EXPORT PSADSRELATIONS;
EXPORT PSADSRELMAP;
EXPORT PSADSSQLREF;
EXPORT PSADSTYPEDEFN;
EXPORT PSADSTYPEITEM;
EXPORT PSPROJADSBIND;
EXPORT PSPROJBINDITEM;
---------------------------------------------------------------------------------------------------------
PSOFT : Tools delivered Import/Export dms scripts
# Version : PT8.5x
cd $PS_HOME/scripts
--------------------------------------------------------------------------------------------------------------
To import & export all User Profiles
1. userimport.dms
2. userexport.dms
This script looks like below and contains these are User Profile Tables:
SET OUTPUT USEREXPORT.DAT;
SET LOG USEREXPORT.LOG;
-- USERS
EXPORT PSOPRDEFN;
EXPORT PSOPRALIAS;
EXPORT PSROLEUSER;
EXPORT PSUSERATTR;
EXPORT PSUSEREMAIL;
EXPORT PSUSERPRSNLOPTN;
EXPORT PS_ROLEXLATOPR;
EXPORT PS_RTE_CNTL_RUSER;
----------------------------------------------------------------------------
To import & export PeopleTools security tables
1. securityimport.dms
2. securityexport.dms
This script looks as below and these tables are Security Tables:
SET OUTPUT SECURITYEXPORT.DAT;
SET LOG SECURITYEXPORT.LOG;
-- ACCESS PROFILES
EXPORT PSACCESSPRFL;
-- USERS
EXPORT PSOPRDEFN;
EXPORT PSOPRALIAS;
EXPORT PSROLEUSER;
EXPORT PSUSERATTR;
EXPORT PSUSEREMAIL;
EXPORT PSUSERPRSNLOPTN;
EXPORT PS_ROLEXLATOPR;
EXPORT PS_RTE_CNTL_RUSER;
-- ROLES
EXPORT PSROLEDEFN;
EXPORT PSROLEDEFNLANG;
EXPORT PSROLECANGRANT;
EXPORT PSROLECLASS;
-- PERMISSION LISTS
EXPORT PSCLASSDEFN;
EXPORT PSAUTHBUSCOMP;
EXPORT PSAUTHCHNLMON;
EXPORT PSAUTHCUBE;
EXPORT PSAUTHITEM;
EXPORT PSAUTHOPTN;
EXPORT PSAUTHPRCS;
EXPORT PSAUTHSIGNON;
EXPORT PSPRCSPRFL;
EXPORT PS_MC_OPR_SECURITY;
EXPORT PS_MC_OPRID;
EXPORT PS_SCRTY_ACC_GRP;
EXPORT PS_SCRTY_QUERY;
-- DEFINITION SECURITY
EXPORT PSOBJGROUP;
EXPORT PSOPROBJ;
-- PERSONALIZATIONS
EXPORT PSUSEROPTNDEFN;
EXPORT PSUSEROPTNLANG;
EXPORT PSOPTNCATGRPLNG;
EXPORT PSOPTNCATGRPTBL;
EXPORT PSOPTNCATTBL;
EXPORT PSOPTNCATLANG;
-- SECURITY OPTIONS
EXPORT PSSECOPTIONS;
-- SECURITY LINKS
EXPORT PSUSEROTHER;
EXPORT PSUSERSELFOTHER;
EXPORT PSROLEOTHER;
EXPORT PSPERMLISTOTHER;
-- USER ID TYPES
EXPORT PSOPRALIASTYPE;
EXPORT PSOPRALIASFIELD;
-- DELETE USER BYPASS TABLE
EXPORT PS_BYPASS_TABLE;
-- FORGOT EMAIL TEXT
EXPORT PSPSWDEMAIL;
-- PASSWORD HINTS
EXPORT PSPSWDHINT;
-- SIGNON PEOPLECODE
EXPORT PSSIGNONPPC;
-- DIRECTORY
EXPORT PSDSDIR;
EXPORT PSDSSRVR;
EXPORT DSCONNECTID;
EXPORT PSDSEXT_INSTALL;
EXPORT PSDSSECMAPMAIN;
EXPORT PSDSSECMAPSRVR;
EXPORT DSUSRPRFLMAP;
EXPORT PSDSUSERPRFL;
EXPORT PSDSSECROLERULE;
EXPORT DSSRCH_SBR;
EXPORT DSSRCHATTR;
EXPORT DSSECFILTER;
EXPORT PT_WF_NOT_DSCFG;
-----------------------------------------------------------------------------
To import & export only PeopleTools tables i.e. No application data
1. mvprdimp.dms
2. mvprdexp.dms
This script looks like below and these Tables are PeopleTools Tables:
SET LOG MVPRDEXP1.LOG
SET OUTPUT MVPRDP1.DAT;
EXPORT PSACCESSPRFL;
EXPORT PSOPRDEFN;
EXPORT PSSTATUS;
SET LOG MVPRDEXP2.LOG;
SET OUTPUT MVPRD2.DAT;
-- PEOPLETOOLS PROJECTS
EXPORT PSPROJECTDEFN WHERE PROJECTNAME LIKE 'PPL%' or PROJECTNAME LIKE 'PT84%';
EXPORT PSPROJECTITEM WHERE PROJECTNAME LIKE 'PPL%' or PROJECTNAME LIKE 'PT84%';
EXPORT PSPROJDEFNLANG WHERE PROJECTNAME LIKE 'PPL%' or PROJECTNAME LIKE 'PT84%';
EXPORT PSPROJECTDEP WHERE PROJECTNAME LIKE 'PPL%' or PROJECTNAME LIKE 'PT84%';
EXPORT PSPROJECTINC WHERE PROJECTNAME LIKE 'PPL%' or PROJECTNAME LIKE 'PT84%';
EXPORT PSPROJECTMSG WHERE PROJECTNAME LIKE 'PPL%' or PROJECTNAME LIKE 'PT84%';
EXPORT PSPROJECTSEC WHERE PROJECTNAME LIKE 'PPL%' or PROJECTNAME LIKE 'PT84%';
SET LOG MVPRDEXP3.LOG;
SET OUTPUT MVPRD3.DAT;
-- SYSTEM
EXPORT PSOPTIONS;
-- RECORDS AND INDEXES
EXPORT PSRECDEFN;
EXPORT PSRECDEFNLANG;
EXPORT PSRECFIELD;
EXPORT PSINDEXDEFN;
EXPORT PSKEYDEFN;
EXPORT PSDDLMODEL;
EXPORT PSDDLDEFPARMS;
EXPORT PSSPCDDLPARM;
EXPORT PSRECDDLPARM;
EXPORT PSIDXDDLPARM;
EXPORT PSRECFIELDDB;
EXPORT PSRECTBLSPC;
-- FIELDS
EXPORT PSDBFIELD;
EXPORT PSDBFIELDLANG;
EXPORT PSDBFLDLABL;
EXPORT PSDBFLDLABLLANG;
-- FIELD FORMATS
EXPORT PSFMTDEFN;
EXPORT PSFMTITEM;
-- TRANSLATES
EXPORT PSXLATDEFN;
EXPORT PSXLATITEM;
EXPORT PSXLATITEMLANG;
-- PAGES
EXPORT PSPNLDEFN;
EXPORT PSPNLDEFNLANG;
EXPORT PSPNLFIELD;
EXPORT PSPNLFIELDLANG;
EXPORT PSPNLFIELDEXT;
EXPORT PSPNLACTIVEX;
EXPORT PSPNLHTMLAREA;
EXPORT PSPNLHTMLLANG;
EXPORT PSPNLCNTRLDATA;
EXPORT PSPNLCTLDATALNG;
EXPORT PSPNLBTNDATA;
EXPORT PSPNLBTNLANG;
EXPORT PSPNLTREECTRL;
EXPORT PSPTPNLRTEDITOR;
-- MENUS
EXPORT PSMENUDEFN;
EXPORT PSMENUDEFNLANG;
EXPORT PSMENUITEM;
EXPORT PSMENUITEMLANG;
EXPORT PSXFERITEM;
-- PANEL GROUPS
EXPORT PSPNLGRPDEFN;
EXPORT PSPNLGRPDEFNEXT;
EXPORT PSPNLGDEFNLANG;
EXPORT PSPNLGROUP;
EXPORT PSPNLGROUPLANG;
-- PEOPLECODE
EXPORT PSPCMPROG;
EXPORT PSPCMNAME;
EXPORT PSPCMSYNCID;
EXPORT PSPCMTXT;
-- QUERIES
EXPORT PSQRYDEFN;
EXPORT PSQRYDEFNLANG;
EXPORT PSQRYBIND;
EXPORT PSQRYBINDLANG;
EXPORT PSQRYCRITERIA;
EXPORT PSQRYEXPR;
EXPORT PSQRYFIELD;
EXPORT PSQRYFIELDLANG;
EXPORT PSQRYFLAGS;
EXPORT PSQRYLINK;
EXPORT PSQRYRECORD;
EXPORT PSQRYSELECT;
-- TREE STRUCTURES
EXPORT PSTREESTRCT;
EXPORT PSTREESTRCTLANG;
-- TREES
EXPORT PSTREEDEFN;
EXPORT PSTREEDEFNLANG;
EXPORT PSTREEBRANCH;
EXPORT PSTREELEAF;
EXPORT PSTREELEVEL;
EXPORT PSTREENODE;
EXPORT PSTREEPROMPT;
EXPORT PSTREESELCTL;
EXPORT PSTREESELNUM;
EXPORT PSTREESELECT01;
EXPORT PSTREESELECT02;
EXPORT PSTREESELECT03;
EXPORT PSTREESELECT04;
EXPORT PSTREESELECT05;
EXPORT PSTREESELECT06;
EXPORT PSTREESELECT07;
EXPORT PSTREESELECT08;
EXPORT PSTREESELECT09;
EXPORT PSTREESELECT10;
EXPORT PSTREESELECT11;
EXPORT PSTREESELECT12;
EXPORT PSTREESELECT13;
EXPORT PSTREESELECT14;
EXPORT PSTREESELECT15;
EXPORT PSTREESELECT16;
EXPORT PSTREESELECT17;
EXPORT PSTREESELECT18;
EXPORT PSTREESELECT19;
EXPORT PSTREESELECT20;
EXPORT PSTREESELECT21;
EXPORT PSTREESELECT22;
EXPORT PSTREESELECT23;
EXPORT PSTREESELECT24;
EXPORT PSTREESELECT25;
EXPORT PSTREESELECT26;
EXPORT PSTREESELECT27;
EXPORT PSTREESELECT28;
EXPORT PSTREESELECT29;
EXPORT PSTREESELECT30;
-- ACCESS GROUPS
EXPORT ACCESS_GRP_TBL;
EXPORT ACCESS_GRP_LANG;
-- COLORS
EXPORT PSCOLORDEFN;
-- STYLES
EXPORT PSSTYLEDEFN;
EXPORT PSSTYLEDEFNLANG;
-- BUSINESS PROCESSES
EXPORT PSBUSPROCDEFN;
EXPORT PSBUSPROCITEM;
EXPORT PSBUSPROCLANG;
EXPORT PSBUSPROCSEC;
EXPORT PSBUSPRIMG;
EXPORT PSBUSPITEMIMG;
EXPORT PSBUSPITEMLANG;
EXPORT PSBUSPRIMGLANG;
-- ACTIVITIES
EXPORT PSACTIVITYDEFN;
EXPORT PSACTIVITYLANG;
EXPORT PSACTIVIMG;
EXPORT PSACTIVIMGLANG;
EXPORT PSSTEPDEFN;
EXPORT PSEVENTDEFN;
EXPORT PSEVENTROUTE;
EXPORT PSMSGAGTDEFN;
EXPORT PSMAPEXPR;
EXPORT PSMAPFIELD;
EXPORT PSMAPLEVEL;
EXPORT PSMAPRECFIELD;
EXPORT PSMAPROLEBIND;
EXPORT PSMAPROLENAME;
-- PROCESS DEFINITIONS
EXPORT PRCSDEFN;
EXPORT PRCSDEFNLANG;
EXPORT PRCSDEFNGRP;
EXPORT PRCSDEFNPNL;
EXPORT PRCSDEFNXFER;
EXPORT PRCSDEFNNOTIFY;
EXPORT PRCSDEFNCNTDIST;
EXPORT PRCSDEFNMESSAGE;
EXPORT PRCSDEFNMETA;
EXPORT PS_PRCSDEFNURL;
EXPORT PS_PRCSDEFNURL_LNG;
EXPORT PS_PRCSDEFNURLKEY;
EXPORT PS_PRCS_RUNPARM;
-- PROCESS SERVERS
EXPORT PS_SERVERCLASS;
EXPORT PS_SERVERDEFN;
EXPORT PS_SERVERDEFN_LNG;
EXPORT PS_SERVERNOTIFY;
EXPORT PS_SERVERMESSAGE;
EXPORT PS_SERVEROPRTN;
EXPORT PS_SERVERCATEGORY;
-- PROCESS TYPES
EXPORT PS_PRCSTYPEDEFN;
EXPORT PS_PRCSTYPEDEFNLNG;
EXPORT PS_PRCSTYPEMETA;
-- PROCESS JOBS
EXPORT PRCSJOBDEFN;
EXPORT PRCSJOBDEFNLANG;
EXPORT PRCSJOBGRP;
EXPORT PRCSJOBITEM;
EXPORT PRCSJOBPNL;
EXPORT PS_PRCSJOBNOTIFY;
EXPORT PS_PRCSJOBCNTDIST;
EXPORT PS_PRCSJOBMESSAGE;
EXPORT PS_PRCSOUTPUTLIST;
EXPORT PS_PRCSOUTDESTTYPE;
EXPORT PS_PRCSSYSTEM;
EXPORT PS_PRCSPURGELIST;
EXPORT PS_PRCS_CAT_TBL;
EXPORT PS_PRCS_CAT_LG_TBL;
-- PROCESS RECURRENCE
EXPORT PRCSRECUR;
EXPORT PRCSRECURLANG;
EXPORT PRCSRECURDATE;
EXPORT PRCSRECUREXEMPT;
-- PROCESS CONTROL
EXPORT PS_SCHDLDEFN;
EXPORT PS_SCHDLDEFNLANG;
EXPORT PS_SCHDLITEM;
EXPORT PS_SCHDLMESSAGE;
EXPORT PS_SCHDLNODEPARM;
EXPORT PS_SCHDLNOTIFY;
EXPORT PS_SCHDLRPTDIST;
EXPORT PS_SCHDLTEXT;
-- DIMENSIONS
EXPORT DIMENSION;
EXPORT DIMENSION_LANG;
EXPORT DIM_CTRL_TBL;
EXPORT DIM_DATA_SRC;
EXPORT DIM_INPUT_FLD;
EXPORT DIM_ROLLUP;
EXPORT DIM_ROLLUP_LVL;
-- ANALYSIS MODELS
EXPORT ANALYSIS_MODEL;
EXPORT ANL_MOD_DAT_SRC;
EXPORT ANL_MOD_DIM;
EXPORT ANL_MOD_DIM_FLD;
-- CUBE TEMPLATES
EXPORT ANALYSIS_DB;
EXPORT ANALYSIS_DB_DIM;
EXPORT ANL_DB_LANG;
EXPORT ANL_DB_QRY_ESS;
EXPORT CUBE_AGG_DEF;
EXPORT CUBE_AGG_DIM;
EXPORT CUBE_FILTER_ITM;
-- BUSINESS INTERLINKS
EXPORT PSIODEFN;
EXPORT PSIODEFNLANG;
EXPORT PSIOINPUTS;
EXPORT PSIOOUTPUTS;
EXPORT PSIOSETTINGS;
-- SQL
EXPORT PSSQLDEFN;
EXPORT PSSQLDESCR;
EXPORT PSSQLHASH;
EXPORT PSSQLLANG;
EXPORT PSSQLTEXTDEFN;
-- FILE LAYOUT DEFINITIONS
EXPORT PSFLDDEFN;
EXPORT PSFLDFIELDDEFN;
EXPORT PSFLDSEGDEFN;
-- BUSINESS COMPONENTS
EXPORT PSBCDEFN;
EXPORT PSBCDEFNLANG;
EXPORT PSBCITEM;
EXPORT PSBCITEMLANG;
-- APP ENGINE PROGRAMS
EXPORT PSAEAPPLDEFN;
EXPORT PSAEAPPLLANG;
EXPORT PSAEAPPLSTATE;
EXPORT PSAEAPPLTEMPTBL;
-- APP ENGINE SECTIONS
EXPORT PSAESECTDEFN;
EXPORT PSAESECTDTLDEFN;
EXPORT PSAESTEPDEFN;
EXPORT PSAESTEPMSGDEFN;
EXPORT PSAESTMTDEFN;
EXPORT PS_AEINSTANCENBR;
EXPORT PS_AELOCKMGR;
-- MESSAGE NODES
EXPORT PSMSGNODEDEFN;
EXPORT PSNODEDEFNLANG;
EXPORT PSCONNECTSTRING;
EXPORT PSNODEURITEXT;
EXPORT PSNODECONPROP;
EXPORT PSNODCONPRPLANG;
EXPORT PSNODEPROP;
EXPORT PSNODEPROPLANG;
EXPORT PSNODESDOWN;
EXPORT PSTRUSTNODES;
-- MESSAGE CHANNELS
EXPORT PSCHNLDEFN;
EXPORT PSCHNLDEFNLANG;
EXPORT PSCHNLNODE;
EXPORT PSSUBCHNL;
-- MESSAGE DEFINITIONS
EXPORT PSMSGATTR;
EXPORT PSMSGDEFN;
EXPORT PSMSGDEFNLANG;
EXPORT PSMSGFLDOVR;
EXPORT PSMSGPARTS;
EXPORT PSMSGREC;
EXPORT PSMSGVER;
-- APPROVAL RULE SETS
EXPORT APPR_HDR_LNG;
EXPORT APPR_RULE_AMT;
EXPORT APPR_RULE_DETL;
EXPORT APPR_RULE_FIELD;
EXPORT APPR_RULE_HDR;
EXPORT APPR_RULE_LN;
EXPORT APPR_RULE_QTY;
EXPORT APPR_RULE_ROLE;
EXPORT PSVAITEM;
EXPORT PSVAITEMIMG;
EXPORT PSVAITEMLANG;
-- IMAGE AND HTMLCATALOG-- CONTENT
EXPORT PSCONTDEFN;
EXPORT PSCONTDEFNLANG;
EXPORT PSCONTENT;
EXPORT PSCONTENTLANG;
-- STYLE SHEETS
EXPORT PSSTYLECLASS;
EXPORT PSSTYLECLASSFNT;
EXPORT PSSTYLSHEETDEFN;
EXPORT PSSTYLECLSLANG;
EXPORT PSSTYLEFNTLANG;
EXPORT PSSTYLEDFNLANG;
-- LANGUAGES
EXPORT PSLANGUAGES;
EXPORT PS_STRINGS_TBL;
EXPORT PS_STRINGS_LNG_TBL;
-- SUBSCRIPTIONS
EXPORT PSSUBDEFN;
-- RECORD GROUP
EXPORT PS_REC_GROUP_REC;
EXPORT PS_REC_GROUP_TBL;
-- CHANGE CONTROL
EXPORT PSCHGCTLHIST;
EXPORT PSCHGCTLLOCK;
-- OBJECT CHANGE (RENAMES)
EXPORT PSOBJCHNG;
-- APP MESSAGING
EXPORT PSAPMSGARCHPC;
EXPORT PSAPMSGARCHPD;
EXPORT PSAPMSGARCHPH;
EXPORT PSAPMSGARCHSC;
EXPORT PSAPMSGARCHTMP;
EXPORT PSAPMSGPUBATTR;
EXPORT PSAPMSGPUBCERR;
EXPORT PSAPMSGPUBCERRP;
EXPORT PSAPMSGPUBCLOCK;
EXPORT PSAPMSGPUBCON;
EXPORT PSAPMSGPUBCSYNC;
EXPORT PSAPMSGPUBDATA;
EXPORT PSAPMSGPUBERR;
EXPORT PSAPMSGPUBERRP;
EXPORT PSAPMSGPUBHDR;
EXPORT PSAPMSGPUBINST;
EXPORT PSAPMSGPUBLOCK;
EXPORT PSAPMSGPUBSYNC;
EXPORT PSAPMSGSUBCERR;
EXPORT PSAPMSGSUBCERRP;
EXPORT PSAPMSGSUBCLOCK;
EXPORT PSAPMSGSUBCON;
EXPORT PSAPMSGSUBCSYNC;
EXPORT PSAPMSGSUBPRCID;
EXPORT PSAPMSGXTB;
-- URL DEFINITIONS
EXPORT PSURLDEFN;
EXPORT PSURLDEFNLANG;
-- PORTAL
EXPORT PSPRSMDEFN;
EXPORT PSPRSMDEFNLANG;
EXPORT PSPRSMATTR;
EXPORT PSPRSMATTRLANG;
EXPORT PSPRSMATTRVAL;
EXPORT PSPRSMATTRVALNG;
EXPORT PSPRSMPERM;
EXPORT PSPRSMSYSATTR;
EXPORT PSPRSMSYSATTRVL;
EXPORT PSPRSMHPASGPGLT;
EXPORT PSPRSMSYNC;
EXPORT PSPRDMDEFN;
EXPORT PSPRDMDEFNLANG;
EXPORT PSPRDMCNTPRV;
EXPORT PSPRUHPERSPGLT;
-- RELATIONSHIPS
EXPORT PSRELATCONTACT;
EXPORT PSRELATIONLANG;
EXPORT PSRELATIONPROP;
EXPORT PSRELATIONSHIP;
EXPORT PSRELPROPLANG;
-- APPLICATION PACKAGES
EXPORT PSPACKAGEDEFN;
EXPORT PSPACKAGELANG;
EXPORT PSAPPCLASSDEFN;
-- ARCHIVE TEMPLATES
EXPORT PS_ARCH_PROJ;
EXPORT PS_ARCH_TBL;
EXPORT PS_ARCH_CTRL;
EXPORT PS_ARCH_OTH_CTRL;
EXPORT PS_ARCH_SQL_LNG;
-- ARCHIVE OBJECTS
EXPORT PSARCHOBJDEFN;
EXPORT PSARCHOBJLANG;
EXPORT PSARCHOBJREC;
-- ARCHIVE TEMPLATES (TYPE 2)
EXPORT PSARCHTEMPLATE;
EXPORT PSARCHTEMPLANG;
EXPORT PSARCHTEMPOBJ;
EXPORT PSARCHTEMPQRY;
EXPORT PSARCHTEMPAE;
-- DIAGNOSTIC PLUGINS
EXPORT PSDIAGREG;
-- CONNECT STRINGS
EXPORT PSCONN;
EXPORT PSCONNLANG;
EXPORT PSCONNPROP;
EXPORT PSCONNPROPLANG;
-- FORMAT DEFINITIONS
EXPORT PSCIREF;
EXPORT PSCIREFLANG;
EXPORT PSCIREFPROPERTY;
EXPORT PSCIREFENUM;
EXPORT PSCISYNCDEFN;
-- EVALUATED NODE TRANSACTION
EXPORT PSNODETRX;
EXPORT PSNODTRXCONPROP;
-- EVALUATED RELATIONSHIP TRANSACTION
EXPORT PSRELATIONTRX;
-- MOBILE PAGE
EXPORT PSMPDEFN;
EXPORT PSMPDEFNLANG;
EXPORT PSMPDEFNDEV;
EXPORT PSMPDEFNDEVLANG;
EXPORT PSMPCONTDEV;
EXPORT PSMPCONTDEVLANG;
EXPORT PSSYSTEMID;
EXPORT PSAUTHMP;
-- DICTIONARY
EXPORT PSSCDICTDEFN;
-- MESSAGES
EXPORT PSMSGSETDEFN;
EXPORT PSMSGSETLANG;
EXPORT PSMSGCATDEFN;
EXPORT PSMSGCATLANG;
-- PROBLEM DEFINITIONS
EXPORT PSOPTPRBTYPE;
EXPORT PSOPTPRBTYPELNG;
EXPORT PSOPTTRN;
EXPORT PSOPTTRNLNG;
EXPORT PSOPTTRNCTLG;
EXPORT PSOPTREC;
EXPORT PSOPTRECLNG;
EXPORT PSOPTFIELD;
-- PORTAL REGISTRY USER FAVORITES
EXPORT PSPRUFDEFN;
-- PORTAL USER REGISTRY HOMEPAGE
EXPORT PSPRUHDEFN;
EXPORT PSPRUHTAB;
EXPORT PSPRUHTABPGLT;
-- SYSTEM PAUSE TIME
EXPORT PSSPTDEFN;
EXPORT PSSPTIMES;
-- TOOLBARS
EXPORT PSTOOLBARDEFN;
EXPORT PSTOOLBARITEM;
-- MAINTENANCE LOG
EXPORT PS_MAINTENANCE_LOG;
-- HOLIDAY DEFINITIONS
EXPORT PSHOLIDAYDEFN;
-- USERS
-- Note: PSOPRDEFN exported separately, see top of script
EXPORT PSOPRALIAS;
EXPORT PSROLEUSER;
EXPORT PSUSERATTR;
EXPORT PSUSEREMAIL;
EXPORT PSUSERPRSNLOPTN;
EXPORT PS_ROLEXLATOPR;
EXPORT PS_ROLEXLATOPR_LNG;
EXPORT PS_RTE_CNTL_RUSER;
-- ROLES
EXPORT PSROLEDEFN;
EXPORT PSROLEDEFNLANG;
EXPORT PSROLECANGRANT;
EXPORT PSROLECLASS;
-- PERMISSION LISTS
EXPORT PSCLASSDEFN;
EXPORT PSAUTHBUSCOMP;
EXPORT PSAUTHCHNLMON;
EXPORT PSAUTHCUBE;
EXPORT PSAUTHITEM;
EXPORT PSAUTHOPTN;
EXPORT PSAUTHQUEUEMON;
EXPORT PSAUTHPRCS;
EXPORT PSAUTHSIGNON;
EXPORT PSAUTHWS;
EXPORT PSPRCSPRFL;
EXPORT PS_MC_OPR_SECURITY;
EXPORT PS_MC_OPRID;
EXPORT PS_SCRTY_ACC_GRP;
EXPORT PS_SCRTY_QUERY;
-- DEFINITION SECURITY
EXPORT PSOBJGROUP;
EXPORT PSOPROBJ;
-- PERSONALIZATIONS
EXPORT PSUSEROPTNDEFN;
EXPORT PSUSEROPTNLANG;
EXPORT PSOPTNCATGRPLNG;
EXPORT PSOPTNCATGRPTBL;
EXPORT PSOPTNCATTBL;
EXPORT PSOPTNCATLANG;
-- SECURITY OPTIONS
EXPORT PSSECOPTIONS;
-- SECURITY LINKS
EXPORT PSUSEROTHER;
EXPORT PSUSERSELFOTHER;
EXPORT PSROLEOTHER;
EXPORT PSPERMLISTOTHER;
-- USER ID TYPES
EXPORT PSOPRALIASTYPE;
EXPORT PSOPRALIASFIELD;
-- DELETE USER BYPASS TABLE
EXPORT PS_BYPASS_TABLE;
-- FORGOT EMAIL TEXT
EXPORT PSPSWDEMAIL;
EXPORT PSPSWDEMAILLANG;
-- PASSWORD HINTS
EXPORT PSPSWDHINT;
EXPORT PSPSWDHINT_LANG;
-- SIGNON PEOPLECODE
EXPORT PSSIGNONPPC;
-- DIRECTORY
EXPORT PSDSDIR;
EXPORT PSDSSRVR;
EXPORT DSCONNECTID;
EXPORT PSDSEXT_INSTALL;
EXPORT PSDSSECMAPMAIN;
EXPORT PSDSSECMAPSRVR;
EXPORT DSUSRPRFLMAP;
EXPORT PSDSUSERPRFL;
EXPORT PSDSSECROLERULE;
EXPORT DSSRCH_SBR;
EXPORT DSSRCHATTR;
EXPORT DSSECFILTER;
EXPORT PT_WF_NOT_DSCFG;
-- PEOPLETOOLS SYSTEM DATA
EXPORT PSCRYPTALGCHAIN;
EXPORT PSCRYPTALGDEFN;
EXPORT PSCRYPTALGPARAM;
EXPORT PSCRYPTCHNDEFN;
EXPORT PSCRYPTDLLDEFN;
EXPORT PSCRYPTKEYSET;
EXPORT PSCRYPTPRFL;
EXPORT PSCRYPTPRFLPRM;
EXPORT PSTIMEZONE;
EXPORT PSTIMEZONELANG;
EXPORT PSDSTTIME;
EXPORT PSCHARSETS;
EXPORT PS_OLAP_ATTRIB_NAM;
EXPORT PS_VERTICAL_MARKET;
EXPORT PS_APP_DES_OBJECTS;
EXPORT PS_APP_DES_OBJ_PAR;
EXPORT PSPGEACCESSDESC;
EXPORT PSOBJSECDESC;
EXPORT PSOPTPARMTYPE;
EXPORT PSLOCALEDEFN;
EXPORT PSLOCALELANG;
EXPORT PSLOCALEOPTNDFN;
EXPORT PSLOCALEORDER;
EXPORT PSCOLLATIONS;
EXPORT PS_CDM_FILE_EXT;
EXPORT PS_AEONLINEINST;
EXPORT PS_WL_TEMPLATE_GEN;
EXPORT PS_WL_TEMPL_GEN_TK;
EXPORT PSGATEWAY;
EXPORT PSRF_FLIST_TBL;
EXPORT PSRF_FLIST_LANG;
EXPORT PSRF_FVIEW_TBL;
EXPORT PSRF_FVIEW_LANG;
EXPORT PS_DECIMAL_POS_TBL;
EXPORT PS_WL_TEMPL_GNTKLN;
EXPORT PSACTIVEXLIC;
EXPORT PS_APPDES_OBJ_PERM;
EXPORT PSXMLSIGNINST;
EXPORT PS_TS_REC_KEYFLDS;
EXPORT PS_TS_REC_TXTFLDS;
EXPORT PS_TS_RECORDS;
EXPORT PS_MCF_IM_SERVERS;
EXPORT PS_MCF_INSTALL;
EXPORT PS_MCFIMNETWORKS;
EXPORT PSMCFRENPERMS;
EXPORT PSMCFSYSTEM;
EXPORT PS_MCFUQTASKCFG;
EXPORT PS_PINGOPTIONS;
EXPORT PSVERITYLOCALE;
EXPORT PS_PTP_TABLE1;
EXPORT PS_PTP_TABLE2;
EXPORT PS_PT_CTI_SWITCH;
EXPORT PS_WF_INSTSTATUS;
EXPORT PSIBWSDLADMIN;
EXPORT PSRENNAMETOPIC;
EXPORT PSTRANSFRM_TST;
EXPORT PSSHADOWSEQ;
EXPORT PS_PTEXEC2RESOURCE;
EXPORT PS_PT_ORA_RESOURCE;
EXPORT PS_PTCS_HANDLER;
EXPORT PS_PTCS_PARAMETERS;
EXPORT PS_PTCS_PARAMSLANG;
EXPORT PS_PTCSSERVICEDEFN;
EXPORT PS_PTCSSRVDEFNLANG;
-- WEB Data
EXPORT PSWEBPROFBROW;
EXPORT PSWEBPROFCOOK;
EXPORT PSWEBPROFDEF;
EXPORT PSWEBPROFILE;
EXPORT PSWEBPROFPROP;
EXPORT PSWEBPROFNVP;
-- XML Service Info
EXPORT PS_XMLSERVICEINFO;
-- EDI OBJECTS
EXPORT PS_ECACTIONCDS;
EXPORT PS_ECACTIONS;
EXPORT PS_ECCVTPROFILE;
EXPORT PS_ECENTITYCDS;
EXPORT PS_ECEXTPARTNER;
EXPORT PS_ECEXTTPLINK;
EXPORT PS_ECGENERAL;
EXPORT PS_ECINMAPFILE;
EXPORT PS_ECINMAPFLD;
EXPORT PS_ECINMAPFLDCVT;
EXPORT PS_ECINMAPREC;
EXPORT PS_ECINMAPRECFLD;
EXPORT PS_ECINTLINK;
EXPORT PS_ECINTPARTNER;
EXPORT PS_ECMAPDEFN;
EXPORT PS_ECMAPPROFILE;
EXPORT PS_ECNAMES;
EXPORT PS_ECOUTMAPCVT;
EXPORT PS_ECOUTMAPFLD;
EXPORT PS_ECOUTMAPREC;
EXPORT PS_ECOUTMAPWHERE;
EXPORT PS_ECPRIEVENTCDS;
EXPORT PS_ECPRODFLTS;
EXPORT PS_ECPROMAP;
EXPORT PS_ECPROTRANS;
EXPORT PS_ECSECEVENTCDS;
EXPORT PS_ECTPALIAS;
EXPORT PS_ECTPCVT;
EXPORT PS_ECTPCVT_HDR;
EXPORT PS_ECTPCVT_LN;
EXPORT PS_ECTPPROFILE;
EXPORT PS_ECTRANS;
EXPORT PS_ECTRANSOPTION;
EXPORT PS_ECTRANSOPVAL;
-- SDK Data
EXPORT PS_SDK_AMORT_PREF;
EXPORT PS_SDK_BUS_EXP_DTL;
EXPORT PS_SDK_BUS_EXP_PER;
EXPORT PS_SDK_COMPANY_TBL;
EXPORT PS_SDK_COUNTRY_TBL;
EXPORT PS_SDK_CURR_CD_TBL;
EXPORT PS_SDK_DEPT_TBL;
EXPORT PS_SDK_EM_MAILLST;
EXPORT PS_SDK_EM_RCVMSGS;
EXPORT PS_SDK_EM_SNDEMAIL;
EXPORT PS_SDK_FILEUTL_AET;
EXPORT PS_SDK_INSTALL;
EXPORT PS_SDK_INTL_FLG_CD;
EXPORT PS_SDK_JOB;
EXPORT PS_SDK_LOCH_TBL;
EXPORT PS_SDK_PERS_DATA;
EXPORT PS_SDK_POS_DATA;
EXPORT PS_SDK_PSTREENODE;
EXPORT PS_SDK_RP_INPUT;
EXPORT PS_SDK_RP_PO;
EXPORT PS_SDK_RP_POLINE;
EXPORT PS_SDK_RP_QUERYWRK;
EXPORT PS_SDK_RP_RESULT;
EXPORT PS_SDK_RP_SALORDER;
EXPORT PS_SDK_RP_SITE;
EXPORT PS_SDK_RP_SOQRY1;
EXPORT PS_SDK_RP_SOQRY2;
EXPORT PS_SDK_RT_TYPE_TBL;
EXPORT PS_SDK_RUNCNTL;
EXPORT PS_SDK_SCRTY_DEPT;
EXPORT PS_SDK_SM;
EXPORT PS_SDK_SM_CONCATE;
EXPORT PS_SDK_SRCHSPREF;
EXPORT PS_SDK_SRCH_SAVE;
EXPORT PS_SDK_STOCK;
EXPORT PS_SDK_STOCKXCHG;
EXPORT PS_SDK_STOCK_PRF;
EXPORT PS_SDK_UPS_COST;
EXPORT PS_SDK_UPS_CST_RES;
EXPORT PS_SDK_UPS_TIME;
-- Performance Monitor Data
EXPORT PSPMCONTEXTDEFN;
EXPORT PSPMEVENTDEFN;
EXPORT PSPMEVENTSET;
EXPORT PSPMMETRICDEFN;
EXPORT PSPMMETRICVALUE;
EXPORT PSPMMONITORGBL;
EXPORT PSPMSYSDEFAULTS;
EXPORT PSPMTABLEMAP;
EXPORT PSPMTRANSDEFN;
EXPORT PSPMTRANSSET;
EXPORT PSPMTRANSSET_LN;
-- Feed Data
EXPORT PS_PTFP_ATTRS;
EXPORT PS_PTFP_ATTRS_LANG;
EXPORT PS_PTFP_CATEGORY;
EXPORT PS_PTFP_CATG_LANG;
EXPORT PS_PTFP_DATATYPE;
EXPORT PS_PTFP_DTYPE_LANG
EXPORT PS_PTFP_DTYPE_IBSO;
EXPORT PS_PTFP_DTYPE_ATTR;
EXPORT PS_PTFP_DATTR_LANG
EXPORT PS_PTFP_FEED;
EXPORT PS_PTFP_FEED_LANG;
EXPORT PS_PTFP_OPTIONS;
EXPORT PS_PTFP_PARMS;
EXPORT PS_PTFP_PARMS_LANG;
EXPORT PS_PTFP_PUB_SITES;
EXPORT PS_PTFP_PVALS;
EXPORT PS_PTFP_PVALS_LANG;
EXPORT PS_PTFP_SECURITY;
EXPORT PS_PTFP_SETTINGS;
EXPORT PS_PTFP_SYSVAR;
-- Mathematical Model
EXPORT PSANALYTICREG;
EXPORT PSOPTCONARRAY;
EXPORT PSOPTCONSEXP;
EXPORT PSOPTINDEX;
EXPORT PSOPTINDEXSET;
EXPORT PSOPTLINEXP;
EXPORT PSOPTMODEL;
EXPORT PSOPTMODELLNG;
EXPORT PSOPTMDLSLVR;
EXPORT PSOPTOBJECTIVE;
EXPORT PSOPTPARARRAY;
EXPORT PSOPTPARAEXPDIM;
EXPORT PSOPTPARSDIM;
EXPORT PSOPTPRED;
EXPORT PSOPTPREDDIM;
EXPORT PSOPTPTMODEL;
EXPORT PSOPTREGION;
EXPORT PSOPTREGIONDIM;
EXPORT PSOPTSETDIM;
EXPORT PSOPTSLICEDIM;
EXPORT PSOPTSLICESET;
EXPORT PSOPTSOLVERPARA;
EXPORT PSOPTVAREXPDIM;
EXPORT PSOPTVARARRAY;
EXPORT PSOPTVARSDIM;
-- File Reference
EXPORT PSFILEREDEFN;
-- File Reference Type code
EXPORT PSTYPECODEDEFN;
-- ACE
EXPORT PSACECUBE;
EXPORT PSACECUBECOLL;
EXPORT PSACECUBECOLMAP;
EXPORT PSACECUBEDIMS;
EXPORT PSACEDIM;
EXPORT PSACEEXPDIMS;
EXPORT PSACEEXPSET;
EXPORT PSACEMDLDEFN;
EXPORT PSACEMDLDEFNLNG;
EXPORT PSACEORGANIZER;
EXPORT PSACEORGMAP;
EXPORT PSACERULE;
EXPORT PSACETREE;
EXPORT PSACEUSRFUNC;
EXPORT PSPNLACEGRDAXIS;
EXPORT PSPNLACEGRDDATA;
-- Web Services for Remote Portlets
EXPORT PSPRSMWSRPCONS;
EXPORT PSPRSMWSRPPROD;
EXPORT PSWSRPCPHDEFN;
EXPORT PSWSRPPLTDEFN;
EXPORT PSWSRPPLTGRPID;
EXPORT PSWSRPPLTKW;
EXPORT PSWSRPPLTKWLANG;
EXPORT PSWSRPPLTLANG;
EXPORT PSWSRPPRDDEFN;
EXPORT PSWSRPPRDLANG;
EXPORT PSWSRPPRDPROP;
-- Java Portlet User Preferences
EXPORT PSJPUPDEFN;
EXPORT PSJPUPPREF;
EXPORT PSJPUPPREFVAL;
-- Services
EXPORT PSSERVICE;
EXPORT PSSERVICELANG;
EXPORT PSSERVICEOPR;
EXPORT PSSERVICEUDDI;
-- Service Operation
EXPORT PSOPERATION;
EXPORT PSOPERATIONLANG;
-- Service Operation Routings
EXPORT PSIBRTNGDEFN;
EXPORT PSRTNGDFNLANG;
EXPORT PSRTNGDFNCONPRP;
EXPORT PSRTNGDFNPROP;
EXPORT PSRTNGDFNPROPLG;
EXPORT PSIBRTNGSUBDEFN;
EXPORT PSRTNGDFNPARM;
-- Service Operation Handlers
EXPORT PSOPRHDLR;
EXPORT PSOPRHDLRLANG;
EXPORT PSOPERATIONAC;
EXPORT PSOPERATIONAE;
EXPORT PSOPERATIONCI;
EXPORT PSOPERATIONDMS;
-- Service Operation Versions
EXPORT PSOPRVERDFN;
EXPORT PSOPRVERDFNLANG;
EXPORT PSOPRVERDFNPARM;
EXPORT PSOPRVERQUEPARM;
EXPORT PSOPRGENRTGPARM;
-- Integration Broker Queues
EXPORT PSQUEUEDEFN;
EXPORT PSIBQUEUEINST;
EXPORT PSQUEUEDEFNLANG;
EXPORT PSQUEUEOVRD;
EXPORT PSQUEUEPART;
-- XML Publisher Data Source
EXPORT PSXPDATASRC;
EXPORT PSXPDATASRCLNG;
EXPORT PSXPSCHEMAFLMN;
EXPORT PSXPSMPLDTMN;
-- XML Publisher File Definition
EXPORT PSFILEDEFN;
EXPORT PSFILEDATA;
-- XML Publisher Report Definition
EXPORT PSXPRPTDEFN;
EXPORT PSXPRPTDEFNLNG;
EXPORT PSXPRPTOUTFMT;
EXPORT PSXPRPTPROP;
EXPORT PSXPRPTSCOPEFLD;
EXPORT PSXPRPTSRCHKEYS;
EXPORT PSXPRPTTMPL;
EXPORT PSXPRPTTMPLCTRL;
EXPORT PSXPRPTVIEWER;
-- XML Publisher Template Definition
EXPORT PSXPTMPLDEFN;
EXPORT PSXPTMPLDEFNLNG;
EXPORT PSXPTMPLFILEDEF;
EXPORT PSXPTMPLTRINFO;
-- Integration Broker Schema
EXPORT PSIBSCMADFN;
EXPORT PSIBSCMADATA;
-- Integration Broker WSDL
EXPORT PSIBWSDLDFN;
EXPORT PSIBWSDLDATA;
-- CONNECTED QUERY
EXPORT PSCONQRSDEFN;
EXPORT PSCONQRSDEFNLAN;
EXPORT PSCONQRSFLDREL;
EXPORT PSCONQRSMAP;
EXPORT PSCONQRSPROP;
-- Document Schema
EXPORT PSDOCSCMADFN;
EXPORT PSDOCSCMADATA;
-- Document Logical Schema
EXPORT PSLSDEFN;
EXPORT PSLSDEFNBODY;
EXPORT PSLSDEFNLANG;
-- Document Logical Dependency
EXPORT PSLSDEPDEFN;
EXPORT PSLSDEPDEFNLANG;
EXPORT PSLSDEPCHLDDFN;
-- Document Physical Schema
EXPORT PSPHYSSCHDEFN;
EXPORT PSPHYSSCHLANG;
EXPORT PSPHYSSCHBODY;
-- Cube Dimension
EXPORT PSCUBDIMENSION;
EXPORT PSCUBATTRIBDIM;
EXPORT PSCUBDIMENGEN;
EXPORT PSCUBDIMENLANG;
EXPORT PSCUBDIMSTRINFO;
EXPORT PSCUBDIMSTRUCT;
-- Cube Outline
EXPORT PSCUBOUTLINE;
EXPORT PSCUBDIMLIST;
EXPORT PSCUBOUTLINLANG;
EXPORT PSCUBOUTQRY;
EXPORT PSCUBOUTQRYCOL;
EXPORT PSCUBOUTQRYINF;
-- Cube Connection
EXPORT PSCUBCONNECTID;
EXPORT PSCUBCONNLANG;
-- Cube Template
EXPORT PSCUBTEMPL;
EXPORT PSCUBTEMPL_LNG;
-- Certificate
EXPORT PSCERTDB;
EXPORT PSCERTDEFN;
EXPORT PSCERTDEFNDEL;
EXPORT PSCERTISSUER;
-- Key
EXPORT PSKEYDB;
EXPORT PSKEYDBDEL;
-- Test
EXPORT PSPTTSTDEFN;
EXPORT PSPTTSTCOMMAND;
EXPORT PSPTTSTERROR;
-- Test Case
EXPORT PSPTTSTCASE;
EXPORT PSPTTSTCASEVAL;
-- Application Data Set
EXPORT PSADSDEFAULTS;
EXPORT PSADSEXCLUSIONS;
EXPORT PSADSRELATIONS;
EXPORT PSADSRELMAP;
EXPORT PSADSSQLREF;
EXPORT PSADSTYPEDEFN;
EXPORT PSADSTYPEITEM;
EXPORT PSPROJADSBIND;
EXPORT PSPROJBINDITEM;
---------------------------------------------------------------------------------------------------------
