Simple exp script

[ErrolDC]

Hi. For the life of me, I cannot seem to figure out how to pass the exp utility variables from within a script. The variables are not recognized by exp and are substituted with white space which makes exp complain about being supplied two values for a parameter. This is a *nix script so if someone can shine the light on my error, I'd be really appreciative.

Thanks

Errol Neal

 

[LKBrwnDBA]

Post your script.


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[ErrolDC]

It's not much. It's just a few lines.

#!/sbin/sh
date="date '+%Y%m%d'"
HOME=/export/home/oracle

ORACLE_SID=tkbpre; export ORACLE_SID
echo "Exporting a copy of the mipttkb schema from tkbpre.."
$ORACLE_HOME/bin/exp log=$HOME/logs/exp-mipttkb\"{$date}".txt  parfile=$HOME/scripts/exp.par

 

[ProblemSolver]

Hi ErrolDC,

Please post the exact error message from EXP.

Regards,

- ProblemSolver

 

[LKBrwnDBA]

Try:

#!/sbin/sh
curdt=`date +%Y%m%d`
HOME=/export/home/oracle

ORACLE_SID=tkbpre; export ORACLE_SID
echo "Exporting a copy of the mipttkb schema from tkbpre.."
$ORACLE_HOME/bin/exp log=$HOME/logs/exp-mipttkb-${curdt}.txt  parfile=$HOME/scripts/exp.par

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[ErrolDC]

Thank you very much LKBrwnDBA. I really appreciate your help.