RE: directory objects
Date: Thu, 28 Feb 2008 13:12:44 -0500
Oracle DIRECTORY objects are usually used with either utl_file or external tables. I see no reason why the data used to feed a utl_file task could not come from a distributed query and I would think you could reference an external table via a remote query though I have never tried it.
NFS mouting definitely works. We do that now.
- Mark D Powell --
Phone (313) 592-5148
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still
Sent: Thursday, February 28, 2008 1:01 PM To: joe_dba_at_hotmail.com Cc: oracle-l_at_freelists.org Subject: Re: directory objects What problem are you hoping to solve with this? On Thu, Feb 28, 2008 at 7:57 AM, Joe Smith <joe_dba_at_hotmail.com>wrote:
Is it possible to use DIRECTORY OBJECTS between servers?
Have DIRECTORY OBJECTS from database A on server A point to and create its files on server B?
Climb to the top of the charts! Play the word scramble
challenge with star power. Play now!
-- Jared Still Certifiable Oracle DBA and Part Time Perl EvangelistReceived on Thu Feb 28 2008 - 12:12:44 CST