os-authentication is best if you are connected locally. However, you can
not use it when exporting from a remote client.
My trick is to echo the password and pass it on to the exp command. ps
command will not show the password nor the echo command.


echo <password> | exp userid=[Email Address Removed] string> full=yes log=test.log

You can also use when exporting with named pipes.


"Terance Ebert " <oracledba-ezmlmshield-x25067642.[Email address protected]
wrote on 03/30/2007 04:32:51 PM:

> create a user using os authentication for the export /import then all
> you need is exp / (make sure your environment is correct if running out

> of cron. also be sure to set ORACLE_SID especially if more than 1 db is
> on the server)
>
> Stephen Price wrote:
> > Is there a way of automating the exp command without hard coding the
> > system password? I am using 10gR2 on Linux RHEL4 and through trial
and
> > error have not found a way to do this without hard coding the system
> > password in a PAR file or exposing the password to anyone able to
> > execute a simple ps command.
> >
> >
> >
> > Cheers,
> >
> > Stephen
> >
> >
> >
> > Stephen Price
> > Oracle Database Administrator
> > Compusearch Software Systems, Inc.
> >
> >
> >
> >
> >
> > ---------------------------------------------------------------------
> > TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> > To post a dba job: http://jobs.lazydba.com
> > To Subscribe : http://www.LazyDBA.com
> > To unsubscribe: http://www.lazydba.com/unsubscribe.html
> >
> >
> >
> >
> >
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>


---

This e-mail may contain confidential and/or privileged information. If you
are not the intended recipient (or have received this e-mail in error)
please notify the sender immediately and destroy this e-mail. Any
unauthorized copying, disclosure or distribution of the material in this
e-mail is strictly forbidden.

Oracle LazyDBA home page