Create Export Par file and use it before refresh of environment

Create Export Par file and use it before  refresh of environment


Create one exp_instancename.par file which contains below part

userid="/ as sysadm"
     2  DIRECTORY=instancename_dir
     3  DUMPFILE=exp.dmp
     4  LOGFILE=exp_instancename.log
     5  tables=(
     6  SYSADM.PS_UC_SERVER_TBL,
     7  SYSADM.PS_RS_SRCH_HDR,
     8  SYSADM.PSNODEURITEXT,
     9  SYSADM.PSNODECONPROP,
    10  SYSADM.PSCONN,
    11  SYSADM.PSCONNPROP,
    12  SYSADM.PSGATEWAY,
    13  SYSADM.PSOPTIONS,
    14  SYSADM.PS_CDM_DIST_NODE,
    15  SYSADM.PSMSGNODEDEFN,
    16  SYSADM.PSTRUSTNODES,
    17  SYSADM.PSCONNECTSTRING,
    18  SYSADM.PSPRDMCNTPRV,
    19  SYSADM.PS_DIRECTORYSETUP,
    20  SYSADM.PS_SERVERDEFN,
    21  SYSADM.PS_SERVERCLASS,
    22  SYSADM.PSURLDEFN
    23  SYSADM.PS_FILE_DIR_FS,
    24  SYSADM.PS_UC_LL_SETUP,
    25  SYSADM.PS_RS_SRCH_HDR
    26  )

save it at some location inside Oracle/XXX/instancename/export/

then login as an oracle user on server and run below statements

export ORACLE_SID = environment name (whatever you have given)

then Run expdp parfile = exp_instancename.par