change the permission on the directory to 660 on directory. where you want to export.
Sorry to say, but you are one of the most disrespectful member here for the all community I've ever seen.
Never following advices to read the pointed out docs, or google. Apparently, never did the effort actually.
Never following advices on how to post question.
Never providing information enough to help us to understand better what the problem is. Most often dropping down the thread by making ridiculous comments.
Never pointing to previous thread even though it's obvious linked to an other one. You are assuming that we follow up and read every single of your post to be able understand the last one. You are assuming we are sit next to you seeing the screen. You are assuming we know what you are talking about.
You are most often asking question as soon as they come up to the top of your head without thinking a bit before hands.
And I probably missed a lot of other thing...
Enough is enough.
Thanks, but even I change the folder to 777 the output is still rw to owner only and cannot be accessed by the group member
Can you try it on your linux machine please....
post the cmd you used
Why linux ? You said you were on AIX. Why should we try where you did not show us a little bit of effort you did. Once more, lack of respect.
eBacause linux and aix have the same behavior. I know it is hard to acquire aix as it it expensive
What effort is that Sir? It is just plain expdp system/manager tables=hr.emp
It is so weird...I tried it on PROD server and its output has permission "-rw-r----" for the expdat.dmp and "-rw-r--r--" for it export.log.
Could it be attributed to umask ? Please help test and investigate. It's very late now here....going home now. byebyeeee and thanks
Can i ask you, why do u want to change the permission of the dump file.
***Can i ask you, why do u want to change the permission of the dump file.
Because the output is owned by "Oracle:dba" . The one running the batch job is "oper01:batch", This user can not read,write,delete his own file.
The oracle is creating dump file with permission "-rw-r----" for the expdat.dmp and "-rw-r--r--" for it export.log as you said. I tried changing umask but it is not making any difference for it. so if you want to change the permission then you have to manually change it, using chmod cmd in linux.
I presented the changes from traditional EXP backup system of our batch APP, there has been a violent reaction from the operations group because there will be lots of changes to batchprocess.
The major question and
the major change is the APP folder "/u07/batch/dump" which is currently owned by "batchuser:batch" and are placeholder of exp dump for daily/monthly transaction tables, will be changed owned to "oracle:dba" and the operations group do not allow this change. Is there a way that the directory_dump_dir can be owned by user other than oracle?
1 person found this helpful
Can't you just add oracle into the batch group?
We changed permission of the expdp folder "/u07/batch" to "batchuat:dba" with chmod "770" and this seemed to work
I thank you all
Yikes...sorry the output dump file is still owned by " oracle" user so the "batchuat" can not remove it for file maintenance.