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

Posted on 2008-11-14
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
    LVL 9

    Accepted Solution


    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 34

    Assisted Solution

    Wouldn't the IP need to contain periods and not colons?

    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
    How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
    This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
    This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

    754 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

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now