Re: Remote Oracle Directory for LOB loading
- From: Kim Berg Hansen <kibeha@xxxxxxxxx>
- To: cjnewman@xxxxxxxxxxxxx
- Date: Thu, 30 Oct 2014 15:54:34 +0100
Hi, Chris
We used to have an NFS mount on a remote Windows server mounted locally on
the Linux database server. We use external tables to query data from files
on that mount.
But the Windows NFS server was not very stable (either Microsoft problem or
bad setup, we don't really know), so we switched to CIFS mounting.
Now it is a Windows share on the Windows server, and the Linux database
server CIFS mounts that share. It works much better for us than NFS.
But that is because the NFS share came from Windows - those places where
both sides are Unix or Linux we use NFS and it works good.
We have no experience with Direct NFS, but I read this link:
http://www.pythian.com/blog/oracle-direct-nfs-how-to-start/
And it seems like there are advantages to using Direct NFS if it is an NFS
mount you are using.
But no matter if it is NFS or CIFS, you introduce (like Øyvind states)
something external that your database becomes dependent on.
It'll depend on the use case if that's acceptable or not. Loading the files
clientside with SQL*Loader eliminates that issue.
Regards
Kim Berg Hansen
http://dspsd.blogspot.com
kibeha@xxxxxxxxx
@kibeha
On Thu, Oct 30, 2014 at 3:04 PM, Newman, Christopher <cjnewman@xxxxxxxxxxxxx
> wrote:
> 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
>
>
Other related posts:
