Mapping the oracle database directory object to a network path

Question

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?

dba.stackexchange.com is the best spot for dba questions.

Mike Gardner
– Mike Gardner

2014-06-03 15:16:17 +00:00
Commented Jun 3, 2014 at 15:16 — Mike Gardner
– Mike Gardner, Commented Jun 3, 2014 at 15:16

Bob Jarvis - Слава Україні · Accepted Answer · 2014-06-03 15:55:39Z

1

Use the CREATE OR REPLACE DIRECTORY... variant of this command:

CREATE OR REPLACE DIRECTORY RESULT AS '\\ServerName\ShareName\SomeOtherDir'

Share and enjoy.

answered Jun 3, 2014 at 15:55

Bob Jarvis - Слава Україні

50.2k10 gold badges81 silver badges119 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Konstantinos Over a year ago

If the network path has credentials (windows server) how can we pass the username & password?

Bob Jarvis - Слава Україні Over a year ago

@Konstantinos: that should be asked as a separate question on dba.stackexchange.com. Thanks.

Govind Gupta Over a year ago

Is there any way to give ip name with username and password in directory path?

Bob Jarvis - Слава Україні Over a year ago

I have no idea. You should post that as a new question.

Collectives™ on Stack Overflow

Mapping the oracle database directory object to a network path

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related