RE: directory objects

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Thu, 28 Feb 2008 13:12:44 -0500
Message-ID: <D1DC33E67722D54A93F05F702C99E2A90204ED14@usahm208.amer.corp.eds.com>


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

        From: oracle-l-bounce_at_freelists.org
[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?                  

                thanks.                                  


                Climb to the top of the charts! Play the word scramble challenge with star power. Play now!
<http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_ jan>

	-- 
	Jared Still
	Certifiable Oracle DBA and Part Time Perl Evangelist
	


--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 28 2008 - 12:12:44 CST

Original text of this message