querying over multiple database links

From: Krzysztof Cierpisz <ciapecki_at_gmail.com>
Date: Tue, 5 Jul 2011 08:01:50 -0700 (PDT)
Message-ID: <9cc3e816-8ce7-4b92-83bb-9f4da6b4ea34_at_e17g2000prj.googlegroups.com>

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_at_dblink_to_remote1

I have another local database db1 with database link to remote2 => _at_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?

chris Received on Tue Jul 05 2011 - 10:01:50 CDT

Original text of this message