Create database link

[yassinemannai]

hi,
I have an Oracle data base (A) and other oracle db ( B)
I want to link A to B with:
create database link link_127 to system identified by manager using 'bib'( bib is in tnsnames.ora )

the link is created.

i have a table in B ( test).

I try this command( I am logged in A)

select * from test@link_127;

but the system generate error
what's the solution

please help me

 

[THoey]

I think I had a similar problem, hard to tell since you don't list the error, but Karluk (the Magnificent) once again helped me resolve it. Please see this link and thank him if it solves your problem:

thread186-88889

Hope that helps... Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.