This content has been marked as final. Show 5 replies
887817 wrote:Create a directory & execute default permission to the directory. Export your database to the directory should do the trick.
I have a problem under Linux : I am creating dump files with datapump.
Those dump files are owned by a dba group, with no read access for users not in the dba group.
Is there a way that the datapump utility creates dump files with a read access given to any user ?
Do you mean a directory with right 777 ?
It is what I have.
The dump file has the rights "rw r "
The log file has the rights "rw r r"
I can move the dump file, but my need is to transfer it with FTP to another server, and for this it seems that I need the "r" right. (unless I have not understood your answer)
Unlike "exp", when using "expdp", the dumpfile is created by the server process. The server process is forked from the database instance. It inherits the umask settings that are present when the database instance is started.
(Therefore, the only way to change the permissions would be to change the umask for the oracle database server id and restart the database instance --- which is NOT what I would recommend).
umask is set so that all database files created (e.g. with CREATE TABLESPACE or ALTER TABLESPACE ADD DATAFILE) are created with "secure" permissions preventing others from overwriting them -- of course, this is relevant if your database files are on FileSystem.
Hemant K Chitale
Thank for this answer.
It clarifies what I can do, or ask.
what would you recommend in order for expdp to create the dump files as 755 ?