querying over multiple database links

Giganews Newsgroups
Subject: querying over multiple database links
Posted by:  Krzysztof Cierpisz (ciapec…@gmail.com)
Date: Tue, 5 Jul 2011

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

Replies