select * from dba_directories shows which directories have been set up and a unix command like test -d /directory tells if the directory does exit test -f tells if the file exists ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of J. Dex Sent: 17 October 2007 16:42 To: oracle-l@xxxxxxxxxxxxx Subject: Directory setting for data pump How can you find out if a directory has already been created for data pump and the location of the directory? I looked in init parms and didn't see it and looked in system tables and didn't see any reference to it. ________________________________ Climb to the top of the charts! Play Star Shuffle: the word scramble challenge with star power. Play Now! <http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_ oct> BJSS Limited, 1st Floor Coronet House, Queen Street, Leeds LS1 2TW. Registered in England with company number 2777575. http://www.bjss.co.uk