Re: exporting

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Fri, 26 Feb 2016 14:16:57 +0000
Message-ID: <CABe10sbtPhfoM3+0Nb_FV-x_+ZU8ikQov2HXT=ZLNxkzvDGw4A_at_mail.gmail.com>



Check the *mount* permissions as well as the filesystem permissions.

On Fri, Feb 26, 2016 at 2:02 PM, Zelli, Brian <Brian.Zelli_at_roswellpark.org> wrote:

> I created directory, did the create and the assign and still the same
> results. I believe it is an NFS mount. I checked the privs and made all
> read, write and execute on the unix directory.
>
>
>
> I can’t figure out what I am missing because we have done this
> before…..and I’ve done it on the test boxes as well…..
>
>
>
> Brian
>
>
>
>
>
> *From:* Mayen Shah [mailto:mshah_at_travelclick.com]
> *Sent:* Friday, February 26, 2016 8:31 AM
>
> *To:* Zelli, Brian
> *Cc:* Chris Stephens; oracle-l (oracle-l_at_freelists.org)
> *Subject:* Re: exporting
>
>
>
> Yes pick another location on os, create another directory object, grant
> privileges and use that for log file. Yes, you can use different directory
> for log file.
>
>
>
> Is existing location nfs mount?
>
>
>
>
> On Feb 26, 2016, at 8:13 AM, Zelli, Brian <Brian.Zelli_at_RoswellPark.org
> <Brian.Zelli_at_roswellpark.org>> wrote:
>
> No there isn't a file there.
> Isn't the log file supposed to go in the same directory as the .dmp file?
>
> I thought it would. It doesn't even get created.
>
>
>
> When you say create a separate directory object, you mean
> create/pick another directory and a new name (like dump_dir2) ?
>
>
>
> Brian
>
>
> ------------------------------
>
> *From:* Mayen Shah <mshah_at_travelclick.com>
> *Sent:* Friday, February 26, 2016 8:01 AM
> *To:* Zelli, Brian
> *Cc:* Chris Stephens; oracle-l (oracle-l_at_freelists.org)
> *Subject:* Re: exporting
>
>
>
> Is there clmprd.log file exist owned by different user or read only
> permissions?
>
>
>
> Another option is to create separate directory object and use that for log
> file to see if it progresses. Creating log file is first step. Next will be
> creating 20160226_clmprd.dmp by expdp.
>
>
>
> - Mayen
>
>
> On Feb 26, 2016, at 5:57 AM, Zelli, Brian <Brian.Zelli_at_RoswellPark.org
> <Brian.Zelli_at_roswellpark.org>> wrote:
>
> Here is what I am running:
>
>
>
> expdp userid/password
>
> directory=DUMP_DIR
>
> dumpfile=20160226_clmprd.dmp
>
> SCHEMAS=roswellclm
>
> Logfile=clmprd.log
>
>
>
> I created the directory dump_dir as /u03/oradata/dumpdir
>
> I gave the userid read, write privs on the directory dump_dir
>
>
>
> I checked at the OS level and the oracle user can read, write to those
> directories.
>
>
>
> I guess the question is, where is the log file going? Does it go to the
> same directory?
>
>
>
> Brian
>
>
>
>
>
> *From:* Chris Stephens [mailto:cstephens16_at_gmail.com
> <cstephens16_at_gmail.com>]
> *Sent:* Thursday, February 25, 2016 7:00 PM
> *To:* Zelli, Brian
> *Cc:* oracle-l (oracle-l_at_freelists.org)
> *Subject:* Re: exporting
>
>
>
> can you give the expdp command and directory ddl?
>
>
>
> On Thu, Feb 25, 2016 at 5:46 PM, Zelli, Brian <Brian.Zelli_at_roswellpark.org>
> wrote:
>
> Getting this error:
>
>
>
> ORA-39002: invalid operation
>
> ORA-39070: Unable to open the log file.
>
> ORA-39145: directory object parameter must be specified and non-null
>
>
>
> I created the directory file and gave rights to the user to write there.
> What am I missing?
>
>
>
> 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.
>
>
>
>
> 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.
>
>
> 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.
>
>
> 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.
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Feb 26 2016 - 15:16:57 CET

Original text of this message