i need to give permission to ORACLE SERVER to create a directory in a particular path.
How to do it?Oracle server is installed in Unix
i need to give permission to ORACLE SERVER to create a directory in a particular path.
How to do it?Oracle server is installed in Unix
What is the error you are getting?
Do you have the access to the unix server and the location where you want to create the folder.
Yes .I have created a procedure in oracle which we will create a folder in the path i have given .But i am getting an error that folder can't be created.
If you want to give permission to oracle to create files under some directory make an entry into ALL_DIRECTORIES with the user you want to run the PL/SQL or data pump etc.
The entry is already there
Could you please post the Oracle user and entry from ALL_DIRECTORIES also the owner and permission details of directory?
Also the exact error message
Can u check if you have write permission to the folder inside which you are creating another folder.
ls -ld foldername
USER DIRECTORY PATH
SYS R_TEST /arbor/integ_fx/rahul_raj/sqlloader_test/sample.txt
i raised this question OTN FORUM https://forums.oracle.com/thread/2554473
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04063: unable to open log file T_EXT_17082.log
OS error No such file or directory
ORA-06512: at "SYS.ORACLE_LOADER", line 19
29913. 00000 - "error in executing %s callout"
*Cause: The execution of the specified callout caused an error.
*Action: Examine the error messages take appropriate action.
---------- Post updated at 12:12 PM ---------- Previous update was at 11:48 AM ----------
Hi i checked
its drwxr-xr-x
Are you the owner of this folder?
Form the permission, it looks only the owner has write access ..not the group or others.
try changing the permission of the folder to 775 or 777.
chmod 775 foldername
or
chmod 777 foldername
I have changed the permission now
Is it still giving the error after you changed the permission of that folder?
I am still getting the error.
What should i do?