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

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 Wed Aug 21 2002 - 07:31:38 CDT