Link to home
Create AccountLog in
Avatar of walkerdba
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]$
Avatar of deviprasad_s
deviprasad_s
Flag of India image

the information you give is incomplete,

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
ASKER CERTIFIED SOLUTION
Avatar of Tintin
Tintin

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of rajeev2353
rajeev2353

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
Avatar of walkerdba

ASKER

Yes, this is fine. I am satisfied with the answer.