Shell script of Oracle Datapump.

  
Hi Code seeker,

I am explaining shell script of datapump and upload file in FTP.


Create file script with datapump_ftp.sh name and grant execute permission.

/u01/datapump_ftp.sh
chmod u+x datapump_ftp.sh



#!/bin/sh
ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
export ORACLE_HOME
export PATH=$ORACLE_HOME/bin:$PATH
ORACLE_SID=orcl; export ORACLE_SID
today=`date +%Y%m%d%H%M%S`

expdp scott/alam DIRECTORY=DATA_PUMP_DIR DUMPFILE=scott-$today  LOGFILE=scottLOG-$today.log
zip -r /u01/app/oracle/admin/orcl/dpdump/scott-$today.zip /u01/app/oracle/admin/orcl/dpdump/scott-$today.dmp

cd /u01/app/oracle/admin/orcl/dpdump/

HOST=192.168.0.102
#This is the FTP servers host or IP address.
USER=FTPUser
#This is the FTP user that has access to the server.
PASS=alam
#This is the password for the FTP user.

ftp -inv $HOST << EOF
user $USER $PASS
put scott-$today.zip
bye
EOF