Link to home
Start Free TrialLog in
Avatar of svlloyd1
svlloyd1

asked on

Oracle external table definition

Does the directory that is referenced by an oracle external table definition have to exist on the oracle server, or can it reference a directory on another server on the network?
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Sean Stuber
Sean Stuber

it can be on the network but it must be mounted as a local file system

using \\someserver\some\path   won't work,  the specifics of creating that remote mount are dependent on the operating system

in windows map the remote directory as drive

in unix mount the remote file system as a local directory

in vms create system logical to point to remote location
No split since the accepted post was basically what I posted?
I've requested that this question be closed as follows:

Accepted answer: 250 points for slightwv's comment #a38350893
Assisted answer: 250 points for sdstuber's comment #a38350920

for the following reason:

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.