Re: 8.1.7 to 9.2.0.3 and db-link

From: Abhijith <abhijith_at_nomail.com>
Date: Mon, 23 Jun 2003 13:54:45 +0530
Message-ID: <3EF6B94D.1060605@nomail.com>

Could u please try doing -

  create PUBLIC database link d1
  connect to t1 identified by t1
  using 'SID';

Think this should work in your case.
Abhijith.

Serj wrote:
> Yes. It's work. But... In my database registered ~300 users. I must create
> this link for every end-user? It's DBA nightmare! :)
> However in 8.1.7 it's work OK!
> By the way, function f1 returning single value (by db-link) work without
> error. Error arise while fetch. And this situation is impossible to
> understand.
>
> Tanks for reply,
> Serj
>
> "Abhijith" <abhijith.kashyap_at_oracle.com> ñîîáùèë/ñîîáùèëà â íîâîñòÿõ
> ñëåäóþùåå: news:3EF69346.5070602_at_oracle.com...
>

>>Database link should be created from the destination side.. i.e. user T2
>>in this case.
>>
>>As per the statements below:
>> > connect t1/t1_at_SID
>> >
>> > create database link d1
>> >
>> > connect to t1 identified by t1
>> >
>> > using 'SID';
>> >
>>
>>should be:
>> > connect t2/t2_at_SID
>> >
>> > create database link d1
>> >
>> > connect to t1 identified by t1
>> >
>> > using 'SID';
>> >
>>
>>Hope this helps
>>Abhijith.

>
>
>
>
Received on Mon Jun 23 2003 - 03:24:45 CDT