Hi,

I have used expdp for datapump. The .dmp file is created by the "oracle" user.
my requirement is to make a zipped file of this .dmp file.

What i am trying to do is change the permissions of this .dmp file from 0640 to 0644 and then do a gzip and zip it. Is there any way i can change the permissions of this .dmp file to 0644.

P.s it is created by "oracle" user and i want to change the permission from my UNIX users.

Please help. TIA!

No, you can't change permission of a file until and unless you are the owner of the file/ you are a root user.
If you belongs to oracle user Group, you have read permission. So, you can copy the dump file and do whatever you want to . And one more thing the db dump file is already a compressed file . So, zipping the file doesn't make sense

If it were a compressed file already, then why is the "compression" option available where we can specify metadata_only, data_only, all or none ??

The data_only , metadata_only options are available to know the content you want to dump from DB