to export

This is a shell script to export

I want to export user1


How will edit the below script to export user1


 cat expdp_sch.sh*
#!/bin/sh

set -x
. /ldba/set_sprefuat.sh

USER=$1
#USER=SPAPP

LDBAPSWD=/ldba/${SERVER_ABBREV}/bin/.ldbapswd
LDBAPSWD=${LDBAPSWD}.${ORACLE_SID}
PASSWORD=`grep -w SYSTEM $LDBAPSWD | awk '{print $2}'`

expdp SYSTEM/${PASSWORD} DIRECTORY=DUMP_EXADATA1 DUMPFILE=expdp_${ORACLE_SID}_${USER}_%U.dmp PARALLEL=4 FILESIZE=4G JOB_NAME=expdp_job_${USER} SCHEMAS=$USER LOGFILE=expdp_${ORACLE_SID}_${USER}.log EXCLUDE=STATISTICS

exit 0
nj09mhf0362[oracle:sprefuat1] 71:
thomaslijuAsked:
Who is Participating?
 
slightwv (䄆 Netminder) Commented:
>>How will edit the below script to export user1

From your last question:
You don't.  You pass in the user you want to export.

From a shell prompt:
./expdp_sch.sh user1
0
 
Steve WalesSenior Database AdministratorCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.