Skip to Main Content

SQL & PL/SQL

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!

how to create directory pointing to other other server

JaguarMar 3 2009 — edited Mar 4 2009
Hi guys,

Is it possible to create directory on my production database server using the hard disk of other PC database server? Im trying to implement new multimedia application on my production database server. My application work smoothly with the directory located on production local drive like this

CREATE OR REPLACE DIRECTORY
MDIR AS
'C:\oracle\ord\img\demo\multimedia\uploaded';

I can create directory on my production database server pointing to other pc server
CREATE OR REPLACE DIRECTORY
MDIR AS
'\\pcserver2\demo$\multimedia\uploaded';

BUT upon accessing the application, It seems that it cannot locate my directory on my pcserver2 because of my error:

ORA-22288: file or LOB operation FILEOPEN failed


Is creating directory path to other server prohibited? Thank youi
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 1 2009
Added on Mar 3 2009
6 comments
1,391 views