export dump on crontab

Posted by Roshan on Mar 23, 2018; 6:46am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/export-dump-on-crontab-tp5473.html

Red Hat Linux 6
Oracle Database 11.2.0.4.0

Hi Erman,

I have scheduled a script on crontab. the content is shown below.

When I execute the script manually, it executes. But on crontab, it is not executing.


export ORACLE_HOME=/u01/oracle/dbhome_1
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID=RECONDB

expdp l2tcp/l2tcp  tables=gci_ref_bb_offer,gci_preorder,gci_iptv_zte,gci_premium_log,gci_ref_billing_ticket FILE=GCIEXPDNR`(date +"%d%m%Y%H%M")`.dmp log=GCIEXPDNR`(date +"%d%m%Y%H%M")`.log statistics=none directory=GCIDNR network_link=GCIDNR

I have checked the crontab log file, no error is seen.

cron.cron

Thanks,

Roshan