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: easy
Keywords: ORACLE EXP
Message-ID: <111@mother.dde.uucp>
Date: 24 Oct 88 16:43:44 GMT
References: <397@cjinc.UUCP>
Organization: Dansk Data Elektronik A/S, Herlev, Denmark
Lines: 56

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
..

example 1:

exp <<..
myuser
mypasswd
50000
mydumpfile.dmp
U
Y
Y
..

This will export the user 'myuser' to the file mydumpfile.dmp with
the rows and with compressed extents.

example 2:

exp <<..
system
manager
20000
orabackup.dmp
E
Y
Y
Y
..

This performs an export of the entire database.

(Someone called this 'inline input' to shell - it sounds right
 - but is that the right term ?)

Martin Berg , Danish Data Electronics

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