Mapping the oracle database directory object to a network path

oracle-11g

I'm an accidental DBA. We have oracle database running on windows server.

I created an oracle directory object named 'Result' and mapped it one of the local drives (C:\appResult) on the database server. The front end application creates a report and writes the file to 'Result' and a file thus gets written to C:\appResult. Now, we want to change the file path 'C:\appResult' to some other server in the network (another server in the network). What is the best way to achieve this?

Thanks

Best Answer

If you're talking about moving the path of the directory object, just use the Create or replace option :

CREATE OR REPLACE DIRECTORY Result AS 'c:\newpath';
Related Question