Re: querying over multiple database links
From: Krzysztof Cierpisz <ciapecki_at_gmail.com>
Date: Fri, 8 Jul 2011 01:29:37 -0700 (PDT)
Message-ID: <2ffd16a0-e900-4cc2-b1da-02913cf940d3_at_l18g2000yql.googlegroups.com>
On Jul 7, 3:07 pm, Mladen Gogala <mgog..._at_no.address.invalid> wrote:
> On Thu, 07 Jul 2011 01:07:03 -0700, Krzysztof Cierpisz wrote:
> > yes, tried that already, but I don't have that priv.
>
> Well then, you should pay a visit to your friendly neighbourhood DBA, who
> has all the privileges needed to do the job.
Date: Fri, 8 Jul 2011 01:29:37 -0700 (PDT)
Message-ID: <2ffd16a0-e900-4cc2-b1da-02913cf940d3_at_l18g2000yql.googlegroups.com>
On Jul 7, 3:07 pm, Mladen Gogala <mgog..._at_no.address.invalid> wrote:
> On Thu, 07 Jul 2011 01:07:03 -0700, Krzysztof Cierpisz wrote:
> > yes, tried that already, but I don't have that priv.
>
> Well then, you should pay a visit to your friendly neighbourhood DBA, who
> has all the privileges needed to do the job.
Yeah, that's what I did. I got access to the target database so no
issues for now.
I was just wondering what joel mentioned
'table_name_at_<remote_database>'@<remote_database2> if that is
supported.
thanks,
chris
Received on Fri Jul 08 2011 - 03:29:37 CDT