Re: Remote Oracle Directory for LOB loading

From: Øyvind Isene <oyvind.isene_at_gmail.com>
Date: Thu, 30 Oct 2014 15:17:11 +0100
Message-ID: <CAF+iMcFq6HeYtvgkLz9-bZjj_CYszO9UVy5Xe5iJKyYF0XzBrQ_at_mail.gmail.com>

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_at_uillinois.edu
> 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

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Oct 30 2014 - 15:17:11 CET