RE: directory objects

  • From: "Powell, Mark D" <mark.powell@xxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 28 Feb 2008 13:46:30 -0500

I just ran a little test where from a local instance I selected against
a remote external table whose database is on another server and I was
able to successfully query the data so it is possible to indirectly
reference the directory objects remotely.

-- Mark D Powell -- 
Phone (313) 592-5148 



        From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Finn Jorgensen
        Sent: Thursday, February 28, 2008 11:17 AM
        To: joe_dba@xxxxxxxxxxx
        Cc: oracle-l@xxxxxxxxxxxxx
        Subject: Re: directory objects
        As far as I know, no. The directory would have to be made
available locally through NFS or NAS or something.
        On 2/28/08, Joe Smith <joe_dba@xxxxxxxxxxx> 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!

Other related posts: