| how to use database link on the remote database? [message #237191] |
Sun, 13 May 2007 04:02  |
sertac
Messages: 3
Registered: May 2007
|
Junior Member |
|
|
because 10g does not connect to 7.3.4 directly, I used a middle db 8i.
I created a database link from 8i to 7.3.4 and named it dblinkto_seven, and created another database link from 10g to 8i and named it dblinkto_eight.
the problem is I do not know how to use the databaselink on the remote database.
I have to use it on 10g.
for example this works on 10g:
select * from tab@dblinkto_eight
this also works on 8i:
select * from tab@dblinkto_seven
but this does not work on 10g:
select * from tab@dblinkto_seven@dblinkto_eight
any help appreciated. thanks.
|
|
|
|
|
|
| Re: how to use database link on the remote database? [message #237198 is a reply to message #237191] |
Sun, 13 May 2007 04:42  |
sertac
Messages: 3
Registered: May 2007
|
Junior Member |
|
|
thanks. I tried it already. It works for a table, but it does not work for a function or procedure...
on 8i this works:
select owner_info@dblinkto_seven(103000000000792) from dual
drop synonym ownerinfoseven
create synonym ownerinfoseven for owner_info@dblinkto_seven
but still on 8i this does not work:
select ownerinfoseven(103000000000792) from dual
it says,
ORA-00904: invalid column name
it is sth about creating a synonym for a function i think...
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
