Home » SQL & PL/SQL » SQL & PL/SQL » Accessing remote path using SQL directory (Oracle Database 10g)
Accessing remote path using SQL directory [message #417067] Wed, 05 August 2009 20:08 Go to next message
kramesh_ora
Messages: 1
Registered: August 2009
Junior Member
Hi All,

We have our Architecture such that DB resides on the IBM Server and there is no Admin tier there and the application tier resides on the linux Server.

I am running a script with the following code:

a) CREATE a DIRECTORY DIR_NAME with absolute path that resides on the Application tier.

b) READ the directory using BFILENAME(DIR_NAME, file_name) for the file file_name. But I am getting the following error:

ORA-22288: file or LOB operation FILEOPEN failed No such file or directory

I suspect this is because the directory is on DB machine but the actual OS file system path is on another machine. How can we avoid this issue?

Regards & Thanks
Re: Accessing remote path using SQL directory [message #417069 is a reply to message #417067] Wed, 05 August 2009 20:38 Go to previous message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.

>How can we avoid this issue?
Specify path accessible to DB server.
Previous Topic: ora-00928 Please Help!
Next Topic: ORACLE AND SQL SERVER (migration)
Goto Forum:
  


Current Time: Sun Dec 11 00:25:42 CST 2016

Total time taken to generate the page: 0.13603 seconds