Re: querying over multiple database links

From: Krzysztof Cierpisz <ciapecki_at_gmail.com>
Date: Thu, 7 Jul 2011 01:07:47 -0700 (PDT)
Message-ID: <48261bc4-83ff-4c5c-a66a-7e2cd04b1dad_at_g9g2000yqb.googlegroups.com>



On Jul 6, 11:37 pm, joel garry <joel-ga..._at_home.com> wrote:
> On Jul 6, 1:01 pm, Krzysztof Cierpisz <ciape..._at_gmail.com> wrote:
>
> > On Jul 6, 7:35 pm, joel garry <joel-ga..._at_home.com> wrote:
>
> > > It's been too long since I've done this, but I think what you want to
> > > do is desc <yourpublicsynonym>_at_<remove_database2> (or select * from
> > > user_db_links_at_<remote_database2>, then if you can see that, you have
> > > to make some bizarro usage with quotes and _at_ signs like desc
> > > 'table_name_at_<remote_database>'@<remote_database2>
>
> > I tried but cannot get it working, I googled but cannot find anything.
> > Are you sure it's possible?
>
> > --
> > chris
>
> Not sure, I'd have to play with it, don't have time.  But it should
> be.  What versions did you say?
>
> jg
> --
> _at_home.com is bogus.http://www.wired.com/dangerroom/2011/07/plenty-of-blame-to-go-around-...

I am on 11g

--
chris
Received on Thu Jul 07 2011 - 03:07:47 CDT

Original text of this message