A quick check seems to indicate that with the wallet... I might as well use my password architecture because security wise, if the directory can be accessed, the wallet can just be copied and used without any knowledge of the password. http://www.oracleforensics.com/wordpress/index.php/2010/04/11/oracle-wallet-auto-login-common-misconception-corrected/ On the dbms_datapump side... Some creativity would need to be involved to 'clean up' log and dmp files. Somehow set the date as part of the file name. Access the data pump dir and remove old exports and logfiles. Data pump does now write over a dump file of the same name. This does however have the advantage of not using a password, but probably harder to be as flexable as a korn shell script that can create directories if they don't exist etc. One major beneifit to the script I was writing was it either can export all databases in oratab or just the databases supplied to it at the command line. With dbms_datapump, each database would have to be logged into to start/stop the job if not wanted... a little more work than editing a cron entry for a script that is controlling all the exports on that server... Just some more insight as to where I'm going and where I'm coming from -- just in case other comments come to mind. Best Regards, Joel Patterson Database Administrator 904 727-2546 -----Original Message----- From: D'Hooge Freek [mailto:Freek.DHooge@xxxxxxxxx] Sent: Tuesday, September 27, 2011 10:07 AM To: Patterson, Joel; aprilcsims@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx Subject: RE: expdp without password Joel, You could also use a client side wallet. Or another option would be to not use expdp, but instead use the dbms_datapump pl/sql package. If you program your export with this package, you can use a schedule job to start the export and there would be no need to login. Regards, Freek D'Hooge Uptime Oracle Database Administrator email: freek.dhooge@xxxxxxxxx tel +32(0)3 451 23 82 http://www.uptime.be disclaimer: www.uptime.be/disclaimer -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Joel.Patterson@xxxxxxxxxxx Sent: dinsdag 27 september 2011 15:49 To: aprilcsims@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx Subject: RE: expdp without password Drat. Now I am back where I started, no? about the only thing left (keeping it a simple as possible), is to create an externally authenticated user, no? Joel Patterson Database Administrator 904 727-2546 -- //www.freelists.org/webpage/oracle-l