Ken: When running from cron the user's .profile does not get executed. So your ORACLE_BASE, ORACLE_HOME etc does not get created in your os environment. So on the line that you want to execute the export. Before the exp command add ". ~/.profile &&" (without the double quotes) exp user/password tables.dmp. This will execute the .profile first, set your environments and then do the export.
Ron *********************************************************************** Ron Cetnar Supervising Programmer/Analyst/Oracle DBA ITS - University Applications Development State University of New York at Albany MSC 100 1400 Washington Ave Albany, NY 12222 Email: [EMAIL PROTECTED] Work: (518) 437-4535 Fax: (518) 437-4540 *********************************************************************** -----Original Message----- Sent: Wednesday, December 10, 2003 12:39 PM To: Multiple recipients of list ORACLE-L -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nguyen, David M > Sent: Wednesday, December 10, 2003 12:24 PM > To: Multiple recipients of list ORACLE-L > Subject: Could not run export utility from cron job > I am able to run export utility from CLI manually but when I schedule it to run from cron job on SUN Solaris8 it fails to > run as it does not recognize exp command. Does someone have any idea? Below is the command I run export manually. > $exp user/password tables.dmp > Thanks, > David I'm pretty sure that jobs running out of cron do not source in .profile so you probably don't have the Oracle environment set and therefor exp is not in your PATH. Ken -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Simpson, Ken INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Cetnar INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
