QUESTION POSED ON: 12 October 2005
My problem: I have to select from a table in remote database 'R' from
local database 'L.' The select on the remote table works from other databases 'A,' 'B' and 'C'
without dblinks! (I am not sure how. I always thought dblinks were the only way).
The select on the table from 'A,' 'B' and 'C' works like the following:
select * from owner.table@R.world
My questions: There is no dblink in databases 'A,' 'B' or 'C' named R.world. How does
the select work? How to make it work in 'L' in the same manner?
|
