Path: utzoo!utgpu!water!watmath!clyde!att!osu-cis!tut.cis.ohio-state.edu!bloom-beacon!apple!voder!pyramid!oracle!jdiaz
From: jdiaz@oracle.uucp (Jean Marie Diaz)
Newsgroups: comp.databases
Subject: Re: ORACLE EXPorting via a shell script?
Message-ID: <442@oracle.UUCP>
Date: 12 Oct 88 18:18:32 GMT
References: <397@cjinc.UUCP>
Sender: jdiaz@oracle.uucp
Reply-To: jdiaz@oracle.uucp (Jean Marie Diaz)
Organization: Oracle Corporation, Belmont, CA
Lines: 26

>I need to setup a shell scrip to automaticly export data from
>an ORACLE database using their EXP program.  The problem is that is seams
>to only take input from the keyboard, anyone got any ideas?

Hmm.  Oughta look something like this:

#!/bin/csh
exp recordlength=16384 db/accounts >& logfile <<FINISH_ME_OFF
32768
/export/file/name
T
Y
Y
CPU
.
FINISH_ME_OFF

There are lots of refinements (lock files, logging, etc), but you get the
idea.

Claimers: I claim that 1) I am only a sysadmin for Oracle, and not a
developer. 2) You might not be using the same version of exp as I am.  3)
Ninety gazillion other things might go wrong.

				   AMBAR
ambar%oracle.uucp@hplabs.hp.com			 {hplabs,pyramid}!oracle!ambar