<div>
- to run the script without any password, you will need to run it as the OS User that is in the “DBA”/&quot;ORADBA&quot; group of the OS, and just uses ‘/ as sysdba’ in the script:<br />
<br />
expdp '/ as sysdba' DUMPFILE=dmp1.dmp, dmp2.dmp PARALLEL=2 LOGFILE=dmp.log FULL=y
</div>


- to run the script without any password, you will need to run it as the OS User that is in the “DBA”/"ORADBA" group of the OS, and just uses ‘/ as sysdba’ in the script:

expdp '/ as sysdba' DUMPFILE=dmp1.dmp, dmp2.dmp PARALLEL=2 LOGFILE=dmp.log FULL=y

<div>
I've requested that this question be closed as follows:<br />
<br />
Accepted answer: 500 points for slightwv's comment <a href="https://www.experts-exchange.com/questions/27826256/Using-Oracle-data-Pump-in-scripts-without-password.html?anchorAnswerId=38287369#a38287369" rel="ugc">#a38287369</a><br />
<br />
for the following reason:<br />
<br />
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
</div>


I've requested that this question be closed as follows:

Accepted answer: 500 points for slightwv's comment #a38287369 [https://www.experts-exchange.com/questions/27826256/Using-Oracle-data-Pump-in-scripts-without-password.html?anchorAnswerId=38287369#a38287369]

for the following reason:

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

<div>
points should be divided or not only given to an expert who agrees with a given comment<br />
the given comment should at least be accepted too
</div>


points should be divided or not only given to an expert who agrees with a given comment
the given comment should at least be accepted too

<div>
<div class="content wysiwyg-content">
I would like to use impdp in a shell script without using the sys password. &nbsp;I am setting the Oracle SID in the script before using &quot;impdp / DUMPFILE=dmp1.dmp, dmp2.dmp PARALLEL=2 LOGFILE=dmp.log FULL=y&quot;.
</div>
</div>


I would like to use impdp in a shell script without using the sys password.  I am setting the Oracle SID in the script before using "impdp / DUMPFILE=dmp1.dmp, dmp2.dmp PARALLEL=2 LOGFILE=dmp.log FULL=y".

Using Oracle data Pump in scripts without password?

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.