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!

Copy files from one server to another

BufossApr 18 2019 — edited Apr 18 2019

Hi , I have a load balancer for db between two servers :

Server 1Server 2
TESTDB01TESTDB02
\\192.168.34.110\\192.168.34.111

I have a file text.xlsx which exists both in the paths

\\192.168.34.110\e$\temp

\\192.168.34.111\e$\temp

And I would like to make a copy of file on both servers as new_test.xlsx.

So I have a direcotry defined as follow :

CREATE OR REPLACE DIRECTORY TEST as 'E:\TEMP';

and the copy functionality works but it copy only on the running server (SELECT host_name FROM v$instance)

I am trying to make directories with the following ways

CREATE OR REPLACE DIRECTORY TEST1 AS '\\192.168.34.110\E:\TEMP';

CREATE OR REPLACE DIRECTORY TEST2 AS '\\192.168.34.111\E:\TEMP';

or

CREATE OR REPLACE DIRECTORY TEST1 AS 'TESTDB01\e$\temp';

CREATE OR REPLACE DIRECTORY TEST2 AS 'TESTDB01\e$\temp';

or

CREATE OR REPLACE DIRECTORY TEST1 AS '\TESTDB01\e$\temp';

CREATE OR REPLACE DIRECTORY TEST2 AS '\TESTDB02\e$\temp';

or

CREATE OR REPLACE DIRECTORY TEST1 AS '\\192.168.34.110\e$\TEMP';

CREATE OR REPLACE DIRECTORY TEST2 AS '\\192.168.34.111\e$\TEMP';

BEGIN

UTL_FILE.FCOPY ('TEST1',

                'text.xlsx',

                'TEST1',

                'new_test.xlsx');

UTL_FILE.FCOPY ('TEST2',

                'text.xlsx',

                'TEST2',

                'new_test.xlsx');

END;

/

But I get error

29283. 00000 -  "invalid file operation"

*Cause:    An attempt was made to read from a file or directory that does

           not exist, or file or directory access was denied by the

           operating system.

Any ideas please ?

Thanks in advance

Comments
Post Details
Added on Apr 18 2019
3 comments
1,430 views