Solved

Oracle 10g - ORA-29280: invalid directory path

Posted on 2013-05-29
3
768 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 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 250 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 250 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Parametric query in oracle 6 49
oracle 11g 23 46
passing parameters to sql script oracle 4 26
sort a spool into file output in oracle 1 22
Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

930 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now