Remote Oracle Directory for LOB loading
From: Newman, Christopher <cjnewman_at_uillinois.edu>
Date: Thu, 30 Oct 2014 14:04:34 +0000
Message-ID: <7C5A0D167BEADF4C984A9167609E8E0F750CE499_at_chimbx3.ad.uillinois.edu>
Good morning list,
Date: Thu, 30 Oct 2014 14:04:34 +0000
Message-ID: <7C5A0D167BEADF4C984A9167609E8E0F750CE499_at_chimbx3.ad.uillinois.edu>
Good morning list,
We've inherited a database that loads external files as LOBS. The database (11.2.0.4) had previously resided on the same machine as the directory/LOBS, however now we're separating the database and the LOB files that it needs to load.
I've checked Oracle directories, and there doesn't appear to be a way to indicate a directory located on a remote server.
A colleague suggested an NFS mount on the remote server that would appear local to ours. Has anyone run into this and if so, how did you solve it? My google-fu seems to indicate that this might be accomplished via Direct NFS, but we've not tried it yet.
Thank you - Chris
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 30 2014 - 15:04:34 CET