topic Re: oracle dbms in Operating System - HP-UX

oracle dbms

?? ¿? ?? — Tue, 09 Jan 2001 06:52:53 GMT

How can I export oracle file in cronfile?

Re: oracle dbms

Alexander M. Ermes — Tue, 09 Jan 2001 08:01:00 GMT

Hi there.
add line to cron :

# 42 21 * * 5 su - oracle $ORACLE_HOME/bin/exp user/password parfile=xyz.parfile

parfile sample attached.
Rgds
Alexander M. Ermes

Re: oracle dbms

Alexander M. Ermes — Tue, 09 Jan 2001 08:04:02 GMT

Hi there.
Forgot one parameter in parfile:
file=/.../.../xy.dmp
log=/.../.../xy.log
you can add more parametersfrom the command exp help=yes.

Rgds
Alexander M. Ermes

Re: oracle dbms

Richard Mertz — Wed, 17 Jan 2001 13:10:52 GMT

The only problem with Alexander's solution is that when the export runs, anyone able to do a ps -ef will be able to see the username/password for the oracle account being exported (this may or may not be a problem for you). I believe you can redirect the input and put the username/password in the par file. I'll check when I get in this morning.

Richard Mertz

Re: oracle dbms

Alexander M. Ermes — Wed, 17 Jan 2001 13:22:23 GMT

Hi there. Yes, sorry. Put the username and password as parameter USERID in the parfile.
Rgds
Alexander M. Ermes.

Re: oracle dbms

Joseph C. Denman — Fri, 19 Jan 2001 21:14:19 GMT

I would create script to do the export, and then call the script from the cron. This way you can add additional items such as emailing the log to yourself.