Solved

Oracle 10g - ORA-29280: invalid directory path

Posted on 2013-05-29
3
785 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 77

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Retreiving column names in Windows but not in Unix 11 60
Oracle Listener Not Starting 11 53
grant user/role question 11 32
oracle collections 2 22
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…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
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
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

821 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