walkerdba
asked on
permission
How oracle use get the permission for this
[oracle@new backup]$ mkdir dpump
mkdir: cannot create directory `dpump': Permission denied
[oracle@new backup]$
[oracle@new backup]$ mkdir dpump
mkdir: cannot create directory `dpump': Permission denied
[oracle@new backup]$
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
hi,
please login to root user
oracle$ su root
give the password
# chown oracle.dba path to oracle dir.
and login to oracle, create any directory under oracle dir
please login to root user
oracle$ su root
give the password
# chown oracle.dba path to oracle dir.
and login to oracle, create any directory under oracle dir
ASKER
Yes, this is fine. I am satisfied with the answer.
there are file systemlevel permissions inthe unix world .
so to create a directory for example:here dpump
to make it simple :
the user ,who is loggied in should have permissions to write to the filessytem. in secure way .with users rights ,group rights , there is some thing called as others rights .
here , it seems you are configuring the dpump dir and grant access level privilages to scott user on that directory ,
you need not create one
there is a default directory .
"PS: Oracle introduced a default directory from 10g R2, called DATA_PUMP_DIR, that can be used:
SQL> SELECT directory_path FROM dba_directories WHERE directory_name = 'DATA_PUMP_DIR';
"
case 2) if you dont want to use the default directory ,still want to create the directory
dpump
from
the prompt:
#[oracle@new backup]$ su root
give root password
make directory here
#mkdir dpump
#chmod 777 dpump --later you canreset the permissions,
and gothe procedure .
http://oracledba-training.blogspot.in/2012/04/oracle-data-pump.html
or
follow the manaul:
http://www.oracle.com/technetwork/issue-archive/2009/09-jul/datapump11g2009-quickstart-128718.pdf
if you still have doubts ,
please ping
please do specify the :
oracle Dbms sofware that you are installing ,
oracle 10g,11g, -dpump was introduced in inthis versions only
and the linux operating sytems that you are using ,
redhat linux 5,6, or oracle linux so on
thank you ,
s.deviprasad