Home » SQL & PL/SQL » SQL & PL/SQL » UTL_FILE (Oracle 10g)
UTL_FILE [message #336402] Sat, 26 July 2008 08:07 Go to next message
srivaths
Messages: 60
Registered: June 2005
Location: France
Member

Hi,

Can I create a Oracle Directory Object for a file system path which exists out of the Server (which runs the Oracle DB)?

For Example,

Oracle DB runs in Server1, and the below directory is in Server2.

create or replace directory ext_dir as '/usr/lpar4/ext_dir/';


I am facing problem reading a file thro UTL_FILE. I am able to read it from the same server in which Oracle DB runs. Is it possible to achieve this?

Regards


Re: UTL_FILE [message #336405 is a reply to message #336402] Sat, 26 July 2008 09:06 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
srivaths wrote on Sat, 26 July 2008 06:07
Hi,

Can I create a Oracle Directory Object for a file system path which exists out of the Server (which runs the Oracle DB)?

For Example,

Oracle DB runs in Server1, and the below directory is in Server2.

create or replace directory ext_dir as '/usr/lpar4/ext_dir/';


I am facing problem reading a file thro UTL_FILE. I am able to read it from the same server in which Oracle DB runs. Is it possible to achieve this?

Regards





Oracle RDBMS can only write files to volumes which are "local" to it.
Re: UTL_FILE [message #336413 is a reply to message #336405] Sat, 26 July 2008 10:03 Go to previous messageGo to next message
srivaths
Messages: 60
Registered: June 2005
Location: France
Member

Thank you.
Re: UTL_FILE [message #336416 is a reply to message #336402] Sat, 26 July 2008 10:11 Go to previous message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Or seems local, you can NFS mount it.

Regards
Michel
Previous Topic: table copy from user to user
Next Topic: ANSI SQL Correlation Problem
Goto Forum:
  


Current Time: Tue Dec 06 04:51:27 CST 2016

Total time taken to generate the page: 0.05596 seconds