Re: Directory setting for data pump

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_at_hotmail.com> 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
--
http://www.freelists.org/webpage/oracle-l