thomasliju
asked on
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_AB BREV}/bin/ .ldbapswd
LDBAPSWD=${LDBAPSWD}.${ORA CLE_SID}
PASSWORD=`grep -w SYSTEM $LDBAPSWD | awk '{print $2}'`
expdp SYSTEM/${PASSWORD} DIRECTORY=DUMP_EXADATA1 DUMPFILE=expdp_${ORACLE_SI D}_${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:sprefua t1] 71:
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_AB
LDBAPSWD=${LDBAPSWD}.${ORA
PASSWORD=`grep -w SYSTEM $LDBAPSWD | awk '{print $2}'`
expdp SYSTEM/${PASSWORD} DIRECTORY=DUMP_EXADATA1 DUMPFILE=expdp_${ORACLE_SI
exit 0
nj09mhf0362[oracle:sprefua
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.