sqlplus system/admin@s160579 SQL> @fill.sql SQL> connect / as sysdba SQL> create directory DATAPUMP_DIR as '/u01/bak/pump'; SQL> grant read,write on directory DATAPUMP_DIR to system; SQL> exit $ mkdir /u01/bak $ mkdir /u01/bak/pump $ mkdir /u01/bak/auto $ lsnrctl start $ chmod +x expdp.sh $ chmod +x exp.sh $ crontab -e oracle $ imp system/admin@s160579 FULL=Y FILE=/u01/bak/auto/20141215-15.52-s160579_full_export.dmp $ impdp system/admin@s160579 DIRECTORY=DATAPUMP_DIR DUMPFILE=20141215-15.58-s160579_full_export.dmp