On a 10g database, there isa default datapump directory created. Data Pump uses Oracle Directories, so you need to look in dba_directories, or all_directories if you omit the directory on your datapump job, everything goes to DATA_PUMP_DIR ----- Original Message ---- From: J. Dex <cemail_219@xxxxxxxxxxx> To: oracle-l@xxxxxxxxxxxxx Sent: Wednesday, October 17, 2007 10:41:52 AM Subject: Directory setting for data pump .hmmessage P { margin:0px;padding:0px;} body.hmmessage { FONT-SIZE:10pt;FONT-FAMILY:Tahoma;} 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!