Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Oracle 10g - ORA-29280: invalid directory path

Posted on 2013-05-29
3
Medium Priority
?
809 Views
Last Modified: 2013-05-29
Hi,

I have created a directory for oracle:

SQL> create or replace directory dy_migration as '/opt/smarttrust/dpa/migration_script/dataexport';

Directory created.

SQL> grant read , write on directory dy_migration to dpowner;

Grant succeeded.

SQL> commit;

Commit complete.

===

Im running a procedure that should write an output file but its giving me this error:

ORA-29280: invalid directory path      


What could be the cause?

Tks,
Joao
0
Comment
Question by:joaotelles
3 Comments
 
LVL 78

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 1000 total points
ID: 39204897
Make sure the oracle user has permissions on /opt/smarttrust/dpa/migration_script/dataexport

As the oracle user from a command prompt:
touch /opt/smarttrust/dpa/migration_script/dataexport/mytest

Make sure the file exists after that:
ls -al /opt/smarttrust/dpa/migration_script/dataexport/mytest

If that works, please post the code that is doing the write.
0
 
LVL 35

Accepted Solution

by:
Mark Geerlings earned 1000 total points
ID: 39205624
Is the procedure owned by the Oracle user: dpowner?  Do you use UPPER CASE when you provide the logical directory name in the procedure?  Logical directory names in Oracle (unlike table and column names usually) are case-sensitive and must be entered in UPPER CASE.
0
 

Author Closing Comment

by:joaotelles
ID: 39205760
Tks. It was the permission and create it with upper case.
0

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

963 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question