querying over multiple database links

From: Krzysztof Cierpisz <ciapecki_at_gmail.com>
Date: Tue, 5 Jul 2011 08:12:45 -0700 (PDT)
Message-ID: <5ee5266f-d9f2-4a91-ac70-74bf270a2938_at_t38g2000prj.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?

thanks,
chris Received on Tue Jul 05 2011 - 10:12:45 CDT