Solved

to export

Posted on 2014-02-27
3
207 Views
Last Modified: 2014-06-09
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:
0
Comment
Question by:thomasliju
3 Comments
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 39892535
>>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
 
LVL 22

Expert Comment

by:Steve Wales
ID: 40121512
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question