while writing excel file using oracle plsql onto other machine in windows server getting error as invalid file operation?

Posted on 2008-11-14
Medium Priority
Last Modified: 2013-12-19
create or replace directory authfile_test as '\\172:17:89:82\authfile';
I used this directory in my plsql procedure to write excel file on this machine.

Please note that, operating system is windows and 172:17:89:82 is another machine.
but while excution  getting error invalid file operation.

I tried the same thing on same server and succeed to generate file without any error, but whilw trying to create file onto aother server i got  above error.

Please tell me, is there any network setting or permission need to give to solve this problem.
can we create directory with ip address of another  machine ?
for example \\172:17:89:82\authfile';
Please provide sample example and how to give all rights to write file at other machine not at oracle database server.
Question by:svalekar

Accepted Solution

MarkusId earned 1000 total points
ID: 22959324

Make sure that the os-user who starts the windows-service
for the oracle-db on the oracle db server has the privileges
to write into the directory on the other server.

LVL 35

Assisted Solution

johnsone earned 1000 total points
ID: 22959355
Wouldn't the IP need to contain periods and not colons?

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

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

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

850 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