hide password when using exp and imp
I need to use exp and imp in regular crontab job. I do not want to show the password when I am using this command in sh shell script. Is there a way for me to hide password somewhere?
I have tried the external user of ops$oracle, and ops$oracle has dba previledge to get the data from the schema that i want to get. But i found the data is not transferred correctly, e.g. additional space in the value.
the os is solaris 9
here is my shell script:
expjob.sh
ORACLE_HOME=/orabase
ORACLE_SID=db1
PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_HOME ORACLE_SID PATH
echo `date`>>/mylogfiles/d1/mylog.dat
`exp schema1/password parfile=/oradata/db1/efiles/p1.dat`
echo "exp finished.">>/mylogfiles/d1/mylog.dat
How do i hide password?
Thank you!