Solved

to export

Posted on 2014-02-27
3
208 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Comparison of Amazon Drive, Google Drive, OneDrive

What is Best for Backup: Amazon Drive, Google Drive or MS OneDrive? In this free whitepaper we look at their performance, pricing, and platform availability to help you decide which cloud drive is right for your situation. Download and read the results of our testing for free!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Disk Quota Windows 2012 R2 6 172
oracle numeric condition check 4 47
UTL_FILE invalid file operation 5 58
oracle query 3 34
Preface There are many applications where some computing systems need have their system clocks running synchronized within a small margin and eventually need to be in sync with the global time. There are different solutions for this, i.e. the W3…
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 Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

734 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