RE: Remote Oracle Directory for LOB loading
- From: "Newman, Christopher" <cjnewman@xxxxxxxxxxxxx>
- To: Kim Berg Hansen <kibeha@xxxxxxxxx>
- Date: Thu, 30 Oct 2014 16:18:20 +0000
Thanks Kim et al.,
We’ll give these a look as well as push the application developers to integrate
a process to setup links within the database to the targeted LOBs.
Thanks again!
From: Kim Berg Hansen [mailto:kibeha@xxxxxxxxx]
Sent: Thursday, October 30, 2014 9:55 AM
To: Newman, Christopher
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Remote Oracle Directory for LOB loading
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<mailto:kibeha@xxxxxxxxx>
@kibeha
On Thu, Oct 30, 2014 at 3:04 PM, Newman, Christopher
<cjnewman@xxxxxxxxxxxxx<mailto: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:
