Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambriumusenet.nl!feed.tweaknews.nl!postnews.google.com!u28g2000yqf.googlegroups.com!not-for-mail
From: Krzysztof Cierpisz <ciapecki@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: querying over multiple database links
Date: Thu, 7 Jul 2011 01:07:03 -0700 (PDT)
Organization: http://groups.google.com
Lines: 17
Message-ID: <b7c9610f-665c-4c27-b3af-66f252b69adb@u28g2000yqf.googlegroups.com>
References: <9cc3e816-8ce7-4b92-83bb-9f4da6b4ea34@e17g2000prj.googlegroups.com>
 <c10a99ad-8ed9-4798-9227-5dcd2dff116d@c41g2000yqm.googlegroups.com>
 <08ff6e30-35af-460f-ab73-723732360671@u30g2000vby.googlegroups.com>
 <aeec7aa6-f0be-4d05-bdf0-650814e68235@j15g2000yqf.googlegroups.com>
 <f86d23c9-1092-4e56-84fd-bc519b727bc9@eb1g2000vbb.googlegroups.com> <pan.2011.07.06.23.45.40@gmail.com>
NNTP-Posting-Host: 193.9.13.138
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1310026120 13339 127.0.0.1 (7 Jul 2011 08:08:40 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 7 Jul 2011 08:08:40 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: u28g2000yqf.googlegroups.com; posting-host=193.9.13.138; posting-account=3B7smAoAAABmq17rxiCog3-OpP2Mfh_S
User-Agent: G2/1.0
X-Google-Web-Client: true
X-Google-Header-Order: ASELNKCHRU
X-HTTP-UserAgent: Mozilla/5.0 (X11; Linux i686) AppleWebKit/534.24 (KHTML,
 like Gecko) Chrome/11.0.696.68 Safari/534.24,gzip(gfe)
Xref:  news.cambrium.nl

On Jul 7, 1:45=A0am, Mladen Gogala <gogala.mla...@gmail.com> wrote:
> On Wed, 06 Jul 2011 12:48:15 -0700, Krzysztof Cierpisz wrote:
> > Unfortunately I don't know credentials that were used for creating that
> > public link. I can use it and know the username with which it connects
> > but cannot replicate that db link on my local database.
>
> Actually, you can. If you retrieve DDL statement for the link by using
> DBMS_METADATA, you will get "CONNECT TO <user> IDENTIFIED BY VALUES <...>
> statement, which will enable you to re-create the link. Catch is that you
> still need "select any catalog" privilege, in order to do that.
>
> --http://mgogala.byethost5.com

yes, tried that already, but I don't have that priv.

--
chris