Re: 8.1.7 to 9.2.0.3 and db-link

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 - 02:00:22 CDT