Re: user id to use for running an export (Oracle 817)

Hi,

thanks for that. All good suggestions.

Grace

"Anurag Varma" <avdbi_at_hotmail.com> wrote in message news:um721g722558a1_at_corp.supernews.com...
> Here is what I would suggest:
> * Try not using the sys account if possible (for exp).
> * Put the userid and password in the parfile (userid=user/pass) and
> put proper read/write permissions on parfile
> * In case you have the userid and password in env variables you can have
> a shell script spit the user/pass in the parfile and then the
orig_parfile
> be appended to it
>
> You could try these other things
>
> if you have os authentication ... use that
>
> or if you really have to use sys account
> try
>
> exp '/ as sysdba' parfile=myparfile
>
> put / as sysoper in quotes (run from a priv account)
>
> ...........
> 2 cents
>
> Anurag
>
>
> "Grace Johnston" <grace.johnston_at_ilim.com> wrote in message
news:ajvvq0$pvr$1_at_kermit.esat.net...
> > Hi All,
> >
> > I run daily exports of users and tables on our development database
using
> > the sys user
> >
> > eg. exp sys/password parfile=/home/$parfn.par > /home/exprun.out.
> >
> > However this involves hard-coding the sys password in my script, which
both
> > I and our auditors are unhappy about. I've tried using internal but get
> >
> > EXP-00004: invalid username or password
> > EXP-00030: Unexpected End-Of-File encountered while reading input
> > EXP-00000: Export terminated unsuccessfully
> >
> > Any suggestions ? Is there any way to hide the password or to use
internal
> > id ?
> >
> > thanks in advance,
> > Grace Johnston
> >
> >
>
>
Received on Thu Aug 22 2002 - 05:03:13 CDT