Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Invalid File Id Error

585634Jun 28 2007 — edited Jul 2 2007
Hello,

I am using shell script to run a set of sql scripts againts a 9.2 db.
When the script tries to write a file to a specified location it gives the following error,

DECLARE
*
ERROR at line 1:
ORA-29282: invalid file ID
ORA-06512: at "SYS.UTL_FILE", line 714
ORA-06512: at line 395
ORA-29280: invalid directory path

But if I run the same set of queries in a different box it runs successfully with now issues. We have verified that both versions of Oracle and AIX are one and the same. the directories to which it is trying to write has the same permissions too. Also did a comparison of the objects and didn't see any difference.

Any help in this regard would be greatly appreciated.

Thanks,
Jubil
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 30 2007
Added on Jun 28 2007
3 comments
1,532 views