on database remote1 is a table I want to access => table1
I have a very limited schema/user created on remote2.

remote2 has public database link to remote1, so I can access
table1@dblink_to_remote1

I have another local database db1 with database link to remote2 =>
@dblink_to_remote2

I would like to create a table from remote1 on my local db1.
I can achieve that with export/import (giving remote2 credentials).

Is there a better solution for that task?

thanks,
chris

On Jul 5, 9:20*am, Krzysztof Cierpisz <ciape... (AT) gmail (DOT) com> wrote:
It's been too long since I've done this, but I think what you want to
do is desc <yourpublicsynonym>@<remove_database2> (or select * from
user_db_links@<remote_database2>, then if you can see that, you have
to make some bizarro usage with quotes and @ signs like desc
'table_name@<remote_database>'@<remote_database2>

But there is some other consideration I can't remember, you have to
very carefully follow the syntax for dblinks. Something about the
definition of the @ sign varies depending on its position in the
redirect string. If I even got your dblinks straight.

I know I did something like this back in the 7.3/8.x days, but not
without object creation access to the middle db. Performance is
likely to be bad.

jg
--
@home.com is bogus.
http://www.signonsandiego.com/news/2...ors-out-of-1m/

On Jul 6, 7:35*pm, joel garry <joel-ga... (AT) home (DOT) com> wrote:

I tried but cannot get it working, I googled but cannot find anything.
Are you sure it's possible?

--
chris

On Jul 6, 1:01*pm, Krzysztof Cierpisz <ciape... (AT) gmail (DOT) com> wrote:
Not sure, I'd have to play with it, don't have time. But it should
be. What versions did you say?

jg
--
@home.com is bogus.
http://www.wired.com/dangerroom/2011...aring-warship/

On Jul 6, 11:37*pm, joel garry <joel-ga... (AT) home (DOT) com> wrote:
I am on 11g

--
chris