Re: expdb dump directory

From: Jay Hostetter <hostetter.jay_at_gmail.com>
Date: Tue, 26 Jan 2016 13:11:17 -0500
Message-ID: <CAD7fdYsba2Kb4ZJQnFFnmm-aM8JhJOPPikPuRJAPxXxb-5an4A_at_mail.gmail.com>



Brian,

 You can use whatever directory you want. If the files still exist, compare the location to your list from dba_directories.

 Or just create a new one:

create or replace directory MY_DIR as '/u01/dumpfiles'; grant read,write on directory MY_DIR to BRIAN;

Jay

On Tue, Jan 26, 2016 at 1:01 PM, Zelli, Brian <Brian.Zelli_at_roswellpark.org> wrote:

> Ok, I have to export the database and I know that I have to specify a dump
> directory and assign rights to it.
>
> But if it was done, say a long time ago, how can I tell what the name of
> the directory was the last time I did it?
>
>
>
> I use SELECT * FROM dba_directories; and it gives me a FILEOUTDIR and
> DATA_PUMP_DIR.
>
>
>
> So is it the DATA_PUMP_DIR directory?
>
>
>
>
>
> Brian
>
>
>
>
>
> This email message may contain legally privileged and/or confidential
> information. If you are not the intended recipient(s), or the employee or
> agent responsible for the delivery of this message to the intended
> recipient(s), you are hereby notified that any disclosure, copying,
> distribution, or use of this email message is prohibited. If you have
> received this message in error, please notify the sender immediately by
> e-mail and delete this email message from your computer. Thank you.

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 26 2016 - 19:11:17 CET

Original text of this message