Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Data Pump Import operating system log file ownership

Skip - AbsoluteAug 28 2016 — edited Sep 8 2016

I want to find out if the Data Pump Import program can create the log file so it is owned by the UNIX user who runs Data Pump Import.  I am just beginning to learn UNIX file and execute permissions.

Here are the settings for Data Pump Import:

[abs01 unv_dir]$ ls -l /opt/app/oracle/product/11.2.0/dbhome_1/bin/impdp

-rwxr-x--x 1 oracle oinstall 176253 Jul 29  2012 /opt/app/oracle/product/11.2.0/dbhome_1/bin/impdp

Currently, when UNIX user abs01 runs Data Pump Import (impdp), impdp creates logfile sodvm_imp.log, owned by oracle, with 'rw-r--r--' rights.  oracle is a member of group oinstall. 

-rw-r--r-- 1 oracle       oinstall       7579 Aug 27 14:12 sodvm_imp.log

The goal is for the log file to be created as:

-rw------- 1 abs01 unv01 7579 Aug 28 21:30 sodvm_imp.log

Where abs01 and oracle belong to group unv01, and the log file is in directory abs_dir/unv_dir, which is also the Data Pump directory.

Is it possible?

Thanks for any advice or guidance.

Skip

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 6 2016
Added on Aug 28 2016
5 comments
2,299 views