Hi...question regarding a script for expdp

[Raj Naidu]

Hi

I have written 2 scripts for doing an expdp.

However when i do the expdp using the abcdexp.sh, which inturn read the abcdexp.par file and gets the schema name when we have passed it as the parameter.

The error I am gettign is that multiple directories cannto be mentioned...I have included all my script as weel as the error in the bottom.

Can someone help me out?

./abcdexp.sh abcdexp abcida
(we are exporting a schema thru this script, but when I execute the script it tells me that multiple directories cannot be mentioned)
Can you please check and let me know what I am doing wrong?


Abcdexp.sh
DATE=`date +%y%m%d`
TIME=`date +%H%M`
schema=$1
firstsch=`echo ${schema}|cut -d"," -f1`
echo $firstsch
. /u02/app/oracle/product/abcdb/db/admin/abcd/scripts/abcd.env
expdp parfile=abcdexp.par schemas="${schema}" dumpfile=${ORACLE_SID}.${firstsch}.$DATE.$TIME.dmp logfile=${ORACLE_SID}.${firstsch}.$DATE.$TIME.log


Abcdexp.par
userid='system/tw8Fd2Gb as sysdba'
parallel=2
directory='DB_EXP_DIR'


HERE IS the error I am getting.

I ran a bash –x Abcdexp.sh

+ expdp parfile=abcdexp.par schemas= dumpfile=abcd1..110216.1430.dmp logfile=abcd1..110216.1430.log
LRM-00112: multiple values not allowed for parameter 'directory'
LRM-00113: error when processing file 'abcdexp.par'