On 8/2/05, shadowbox <[EMAIL PROTECTED]> wrote: > hello list, pardon and medyo off-topic po. > > patulong naman - this is my first time to do some oracle and i'm > having problems with oracle exp and cronjobs. i want to do a scheduled > db export pero hindi ko mapagana sa cron. kapag sa prompt ko binabato > yung command, gumagana - pero pag sa cron ko na nilalagay, ayaw. > > ito yung command: > > /opt/oracle/product/9.2.0/bin/exp parfile=/home/oracle/orabackup/parfile.par > > here's the crontab entry: > > * 12 * * * /opt/oracle/product/9.2.0/bin/exp \ > parfile=/home/oracle/orabackup/parfile.par > > i also tried wrapping the task in a shell script pero ayaw pa rin. > anything i missed?
is the export running with the oracle env vars? my export script has this line: . /home/TSS/dbadmin.profile which sets the oracle environment need to run the export. hth. erik -- roderick e. tapang, nclp retapang at gmail dot com (o_.' http://counter.li.org/ //\ ---------------------- V_/_ Linux User # 253842 _________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List [email protected] (#PLUG @ irc.free.net.ph) Read the Guidelines: http://linux.org.ph/lists Searchable Archives: http://archives.free.net.ph
