Windows service getting mapped drives

[acl03]

Is there a way to have a windows service access a mapped network drive?

We have oracle running on c:\. The actual table structure is on d:\.

D:\ is failing, so we want to move it's contents, directory structure in tact, to another server. Then I'd remove d:, and map d: to the remote server. I figured oracle would be none the wiser.

Turns out since oracle is running as a service (and no the currently logged on user who has the new mapped d: drive) it can't see that drive letter.

So - is there any way to have a windows service get a mapped network drive?



Thanks,
Andrew

 

[markdmac]

Switch from the drive letter to a UNC path.

I hope you find this post helpful.

Regards,

Mark

Check out my scripting solutions at

http://www.thespidersparlor.com/vbscript

Work SMARTER not HARDER. The Spider's Parlor's Admin Script Pack is a collection of Administrative scripts designed to make IT Administration easier! Save time, get more work done, get the Admin Script Pack.

 

[acl03]

Well I'd love to do that, except I'm not an oracle DBA (ours is out for a while on sick leave). Not sure how to modify oracle to point to anything other than it's current settings...

Was hoping to find a way to have oracle think the stuff was in the same place.



Thanks,
Andrew

 

[markdmac]

Tek-Tips has a very good Oracle forum, I am certain they could assist you.

I hope you find this post helpful.

Regards,

Mark

Check out my scripting solutions at

http://www.thespidersparlor.com/vbscript

Work SMARTER not HARDER. The Spider's Parlor's Admin Script Pack is a collection of Administrative scripts designed to make IT Administration easier! Save time, get more work done, get the Admin Script Pack.

 

[acl03]

Ok, I'll post there - thought it was a windows issue, but it's probably better off there. Thanks.



Thanks,
Andrew