Re: Remote Oracle Directory for LOB loading
- From: Øyvind Isene <oyvind.isene@xxxxxxxxx>
- To: cjnewman@xxxxxxxxxxxxx
- Date: Thu, 30 Oct 2014 15:17:11 +0100
Have you consider using SQL*Loader for this? Check out this article by Dr
Tim Hall:
http://oracle-base.com/articles/10g/load-lob-data-using-sql-loader.php
It is pretty simple to setup, but then I don't know how complicated your
current setup is. Using NFS is possible on the database server, but unless
you know what you are doing, you may introduce instability to your
production system. A client solution will have less risk attached to it.
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
>
>
--
Øyvind Isene
+47 90864882
Other related posts:
