-
1. Re: data pump file permissions
Fran Jun 19, 2013 1:01 PM (in response to 988012)1) check if your user have the correct privilege (directory), if not:
GRANT READ,WRITE ON DIRECTORY <your_directory> TO <your_user>;
2) check the permissions of oracle user at OS, and who is the owner of this directory:
ls -l <directory>
*if your user is the owner, he could modify it with "chmod XXX <DIRECTORY>", if (for example) root is the owner, you can't write on it unless he modifies the permissions on that directory (again with chmod):
http://superuser.com/questions/208606/how-to-change-file-permissions-for-a-directory-in-one-command
3) if you can't modify the permissions of this directory, create a new directory in other path (where your user can write).
-
2. Re: data pump file permissions
988012 Jun 19, 2013 1:12 PM (in response to Fran)Hi Fran,
this is not what i am expecting.
i want the permission of dump files should get change when it is generated when we take the export.
-
3. Re: data pump file permissions
DK2010 Jun 19, 2013 1:59 PM (in response to 988012)Hi,
You can not do it by database side, you have to choose the alternate from OS side. one method you can use setfacl
check with your system admin who provide you the command to access on directory so you can read write that files.
HTH
-
4. Re: data pump file permissions
TSharma-Oracle Jun 19, 2013 2:12 PM (in response to 988012)What are the permissions on the dumpfile after it has been created? Set umask to 022 if this has not already set to.
-
5. Re: data pump file permissions
988012 Jun 19, 2013 8:21 PM (in response to TSharma-Oracle)no umask will change the permission for all other files
-
6. Re: data pump file permissions
TSharma-Oracle Jun 19, 2013 9:07 PM (in response to 988012)What are the permissions on the dumpfile after it has been created? What other files you are talking too?