Path: utzoo!attcan!uunet!mcvax!enea!dkuug!dde!mbe
From: mbe@dde.uucp (Martin Berg)
Newsgroups: comp.databases
Subject: Re: ORACLE EXPorting via a shell script?
Summary: Sorry - it is easy but not this way
Keywords: ORACLE EXP
Message-ID: <112@mother.dde.uucp>
Date: 25 Oct 88 17:28:06 GMT
References: <397@cjinc.UUCP> <111@mother.dde.uucp>
Organization: Dansk Data Elektronik A/S, Herlev, Denmark
Lines: 35

In article <111@mother.dde.uucp>, mbe@dde.uucp (Martin Berg) writes:
> In article <397@cjinc.UUCP>, greg@cjinc.UUCP (Gregory F. Hogg) writes:
> > Hello,
> > 	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?
> > 
> > 				Greg
> 
> I use following method (it is dependent on your ORACLE-authorisation) :
> 
> exp <<..
> <user>
> <password>
> <return> or 'array fetch buffer size'
> <return - for expdat.dmp> or <export filename>
> U
> Y
> Y
> ..

I'm sorry, but I have made a small error - the right way to do it is
as follows:

exp <user>/<password> <<..
<return> or 'array fetch buffer size'
<return - for expdat.dmp> or <export filename>
U
Y
Y
..

Martin Berg , Danish Data Electronics

UUCP: ...!mcmax!diku!dde!mbe