You can look in the dba_directories view. SQL> desc dba_directories Name Null? Type ----------------------------------------- -------- ---------------------------- OWNER NOT NULL VARCHAR2(30) DIRECTORY_NAME NOT NULL VARCHAR2(30) DIRECTORY_PATH VARCHAR2(4000) On 10/17/07, J. Dex <cemail_219@xxxxxxxxxxx> wrote: > > 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. -- Don Seiler oracle: http://ora.seiler.us ultimate: http://www.mufc.us -- //www.freelists.org/webpage/oracle-l