###############################
#
# Import Data Pump create SQLFILE script
#
#
#
###############################
for i in 1
do
PWD=`pwd`
DPAREX=`sqlplus -s /nolog<<END
connect / as sysdba
set pages 100 lines 220 heading off feedback off
select * from
(select DIRECTORY_NAME
from dba_directories
where DIRECTORY_PATH like '${PWD}%')
where rownum <2
/
END`
echo -e "The datapump directory is called: = \t${DPARE}\n\n"
if [ -z ${DPAREX} ]
then echo -e "Incorrect directory - change\n\tABORTING!!!"
else
echo "Correct directory"
DPARE=`echo ${DPAREX}`
export DPARE
echo ${DPARE}
echo "Enter schema: "
read SCHEMA
export ORACLE_OWNER=${LOGNAME}
# DT=`date '+%Y%d%m%H%M'`
DT=`date '+%Y%m%d_%H%M'`
EXPDF=`ls expdp*.dmp | cut -f-4 -d"_" | uniq`
TRUNCF=`ls expdp*.dmp | cut -f-4 -d"_" | uniq | cut -f1-3 -d"_" | uniq`
FBDT=`date "+\"TO_TIMESTAMP('%d/%m/%Y %H:%M:%S','DD-MM-YYYY HH24:MI:SS')\""`
PCNT=`ls expdp*.dmp | cut -f-4 -d"_" | uniq | wc -l`
#
# Test Script
#
echo -e " nohup impdp \"/\" \\"
echo -e " directory=${DPARE} \\
dumpfile=${TRUNCF}_%U.dmp \\
logfile=impdp${SCHEMA}_${DT}.log \\
JOB_NAME=IMP_${SCHEMA}_${DT} \\
SQLFILE=IMP_${SCHEMA}_${DT}.sql \\
PARALLEL=${PCNT} &"
#
fi
echo -e "\n\n"
done
